SHOW TABLE STATUS FROM test; SHOW FULL COLUMNS FROM table_name; SHOW CREATE TABLE foobar;
USE mydatabase; SHOW VARIABLES LIKE 'character_set_database'; SHOW VARIABLES LIKE 'collation_database'; SHOW VARIABLES;
语法,语义,语用
SHOW TABLE STATUS FROM test; SHOW FULL COLUMNS FROM table_name; SHOW CREATE TABLE foobar;
USE mydatabase; SHOW VARIABLES LIKE 'character_set_database'; SHOW VARIABLES LIKE 'collation_database'; SHOW VARIABLES;