mysql中一些小众的命令&语句也值得你了解

SHOW TABLE STATUS LIKE 'sys_operation_log'

SHOW COLUMNS FROM pms2_log.sys_operation_log = desc xxxtable

SHOW CREATE TABLE pms2_log.sys_operation_log

RENAME TABLE pms2_log.sys_operation_log TO pms2_log.sys_operation_log_bak20191116;

RENAME TABLE pms2_log.sys_operation_log_copy1 TO pms2_log.sys_operation_log;

SHOW CREATE TABLE bs_package

SET PROFILING = 1

SHOW STATUS

SHOW TABLE STATUS

show status like 'Threads%';

show variables like '%max_connections%';

show variables like '%connect%';

select @@version;