HSQLDB常用命令

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 |... }