1、查询所有表
SELECT * FROM INFORMATION_SCHEMA.TABLES
2、查询语句，带分页
SELECT [LIMIT n m] [DISTINCT]
{ selectExpression | table.* | * } [, ... ]
[INTO [CACHED|TEMP|TEXT] newTable]
FROM tableList
[WHERE Expression]
[ORDER BY selectExpression [{ASC | DESC}] [, ...] ]
[GROUP BY Expression [, ...] ]
[UNION [ALL] selectStatement]
3、创建表
CREATE [TEMP] [CACHED|MEMORY|TEXT] TABLE name
( columnDefinition [, ...] )
columnDefinition:
column DataType [ [NOT] NULL] [PRIMARY KEY]
DataType:
{ INTEGER | DOUBLE | VARCHAR | DATE | TIME |... }
