Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
setting a foreign key (MySQL 5.0)
Name: liliyaw Date: March 30, 2006 at 11:48:25 Pacific OS: linux CPU/Ram: 524 Product: don't know
Comment:
Hello everyone, I'd like to be able to mark one of the columns in table "table1" to be a foreign key from table "table2". Both tables are already populated with data. I'm using MySQL 5.0 So I'd like to do something like this: ALTER TABLE table1 ADD FOREIGN KEY (column_to_modify) REFERENCES table2 (id) ON DELETE CASCADE ON UPDATE NO ACTION;
I get an error when I do this. I will appreciate any input, thank in advance.
Summary: Can anyone tell me what Authentication Protocol MySQL 5.0 uses? It appears to me that there are only 3 options: config, http or cookie based. But which one of them? ...
Summary: You can follow the instructions in the MYSQL manual under the heading MYSQL 5.0 FREQUENTLY ASKED QUESTIONS->SECURITY->RESET ROOT PASSWORD. ...
Summary: If you want a list of all the sales by the top 20 salespeople, you may well need to use a subquery or a view. Note: this syntax should work in mysql 5.0 and higher. I can't make any promises about ea...
0 
