HELP 帮助用户了解数据库中各种对象的结构
SHOW 帮助用户了解某种对象的定义,即返回其DDL语句
EXPLAIN 返回一个SQL语句经优化处理后的执行步骤
FALLBACK 对数据加以保护的一种方式,是冗余的备份
RENAME 对表重命名
NULLIFZERO 对数据作累计处理时,忽略零值
ZEROIFNULL 对数据作累计处理时,将空值作零处理
WITH...BY 对详细数据记录作分类统计(Sub-Total)时有用
MODIFY USER/DATABASE
HELP
HELP DATABASE databasename;
HELP USER username;
HELP TABLE tablename;
HELP VIEW viewname;
HELP MACRO macroname;
HELP COLUMN table or viewname.*;
HELP COLUMN table or viewname.colname . . ., colname;
HELP INDEX tablename;
HELP STATISTICS tablename;
HELP CONSTRAINT table or viewname.constraintname;
HELP JOIN INDEX join_indexname;
HELP TRIGGER triggername;
HELP PROCEDURE procedurename;
HELP PROCEDURE procedurename ATTRIBUTES;
HELP 'SQL';