72
votes
14
answers
2.7K
views
How do I see all foreign keys to a table or column?
In MySQL, how do I get a list of all foreign key constraints pointing to a particular table? a particular colu
59
votes
4
answers
1.2K
views
TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
Per the MySQL docs, there are four TEXT types: TINYTEXT TEXT MEDIUMTEXT LONGTEXT What is the maximum length t
60
votes
30
answers
1.7K
views
How do I quickly rename a MySQL database (change schema name)?
The MySQL manual at MySQL covers this. Usually I just dump the database and reimport it with a new name. This
