MySQL in different OSes

2002-07-17 Thread Hanxue Lee
Hi, I just want to know if I can just copy a MySQL database from, say Windows 2000 to Linux. Will it still work? Does it has binary data compabilities? Thank you Yours Truly, Hanxue - Before posting, please check:

Foreign keys in MySQL

2002-07-10 Thread Hanxue Lee
Hi, In the MySQL documentation, it is stated that foreign keys in SQL are not used to join tables, but are used mostly for checking referential integrity (foreign key constraints). Does it mean that constraints are not supported? I need to have Update and perhaps Delete Referential Integrity.