Tag: innodb

72 votes
14 answers
2.6K 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

avatar
Scot
0 1 0 9
asked 07 September, 2021
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

avatar
Venice
0 1 0 9
asked 07 September, 2021
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

avatar
Freida
0 1 0 9
asked 07 September, 2021