MySQL 其他语法

1.set

SET @name = 43;
SET @total_tax = (SELECT SUM(tax) FROM taxable_transactions);

2.show

SHOW CREATE DATABASE test\G
SHOW CREATE TABLE tbl_name
SHOW DATABASES 
SHOW INDEX FROM City\G
SHOW TABLES Syntax

DESCRIBE City;
EXPLAIN ANALYZE SELECT * FROM t1 JOIN t2 ON (t1.c1 = t2.c2)\G
HELP 'data types'
USE db_name