Does mysql support foreign keys?

The answer to this is two-fold.

Yes. MySQL _DOES_ allow the creation of foreign key constraints
(see
http://www.mysql.com and search documentation for the syntax and other information).

However, FKs are only ENFORCED with InnoDB (the default table-type is MyISAM) tables at present. There is a task added to the TODO list for a future version (5.0 or 5.1, I believe) to add full integrity checking on FKs to all table types.

If you require integrity checking via FKs you MUST use InnoDB format tables. MySQL also requires that you manually create an index on columns which are to be referenced in FKs (both the reference column and the referring column) for speed of queries/joins.

آیا این پاسخ به شما کمک کرد؟

 پرینت این مقاله

در همین زمینه

Do you provide phpMyAdmin web interface to manage the MySQL Database?

Yes, we provide that. You can login to DotNetPanel first Create MySQL Database, create MySQL...

How do I delete a table from a database?

Use this SQL command : "DROP TABLE yourtablename"

What are the differences between GROUP BY and ORDER BY... The manual is not clear on this

GROUP BY is a way to sub-total your results, or perform some other "aggregate" function on them....

I'm new to MySQL, where should I start?

The best source of MySQL information is the excellent on-line manual : ...

How can I select random rows from a table?

SELECT * FROM table_name ORDER BY RAND(); Found at...