SQL语句
-
编辑 删除
innodb查询锁
innodb查询锁select r.trx_id waiting_trx_id, r.trx_mysql_thread_Id waiting_thread, r.trx_query waiting_query, b.trx_id blocking_trx_id, b.trx_mysql_thread_id blocking_thread, b.trx_query blocking_query from information_schema.innodb_lock_...
-
编辑 删除
MYSQL常用SQL
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_fksFROM information_schema.KEY_COLUMN_USAGEWHERE REFERENCED_TABLE_SCHEMA = (your schema name ...
