Shulou(Shulou.com)05/31 Report--

What does the commonly used SQL of MYSQL refer to? in view of this question, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

A quick way to list your FKs (Foreign Key references) using the KEY_COLUMN_USAGE view:

SELECT CONCAT (table_name,'.

Column_name,'- >'

Referenced_table_name,'.

Referenced_column_name) AS list_of_fks

FROM information_schema.KEY_COLUMN_USAGE

WHERE REFERENCED_TABLE_SCHEMA = (your schema name here)

AND REFERENCED_TABLE_NAME is not null

ORDER BY TABLE_NAME, COLUMN_NAME

Statistical database size

SELECT concat (table_schema,'.', table_name) table_name

Concat (round (data_length / (1024 * 1024), 2),'M') data_length

Concat (round (index_length / (1024 * 1024), 2),'M') index_length

Concat (round (round (data_length + index_length) / (1024 * 1024), 2),'M') total_size

FROM information_schema.TABLES

ORDER BY data_length DESC

This is the answer to the question about what SQL is commonly used in MYSQL. I hope the above content can be of some help to everyone. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.