Commands	Recital	MySQL	VFP
ALTER	√	√	√
INDEX <index> ON <table>	√
[ REBUILD ]	√
SHARED | EXCLUSIVE	√
;	√
TABLE	√	√	√
[ <database>! ]	√
<table>	√	√	√
[ IGNORE ]		√
ADD	√	√	√
[ COLUMN ]	√	√	√
<column> <constraint>		√
FIRST		√
AFTER <column>		√
(<column> <datatype> [<field constraints>] [,...])	√	√	√
<table constraint>	√	√	√
ALTER	√	√	√
[ COLUMN ] <column>	√	√	√
SET DEFAULT <value>	√	√	√
DROP DEFAULT	√		√
(<column> <datatype> [<field constraint>] [,...])	√		√
CONSTRAINT (<column> SET <field constraint> <value> [,...])	√		√
<table constraint>	√	√	√
CHANGE		√
[ COLUMN ]		√
<column> <constraint>		√
FIRST		√
AFTER <column>		√
MODIFY	√	√
[ COLUMN ]	√	√
<column> <constraint>		√
FIRST		√
AFTER <column>		√
(<column> <datatype> [<field constraint>] [,...])	√
CONSTRAINT (<column> SET <field constraint> <value> [,...])	√
<table constraint>	√	√
DROP	√	√	√
[ COLUMN ]	√	√	√
DROP DEFAULT	√		√
(<column> [,...])	√	√	√
CONSTRAINT (<column> <constraint> [,...])	√		√
<table constraint>	√	√	√
SET	√		√
CHECK <expL>	√		√
[ERROR <message> ]	√		√
DISABLE KEYS		√
ENABLE KEYS		√
RENAME	√	√	√
(<column>,<new column>)	√		√
[TO] <table>		√
ORDER BY <column>		√
<table constraint>	√	√
;	√	√
FROM XML <xml file>	√
LOAD	√
;	√
BEGIN	√		√
TRANSACTION	√		√
[ < transaction-name> ]	√
;	√
CLOSE	√
CURSOR <cursor>	√
;	√
DATABASES	√		√
[ALL]	√		√
;	√
TABLES	√		√
[ALL]	√		√
;	√
COMMIT	√	√	√
[ TRANSACTION  <transaction-name> ]	√
[ WORK ]	√
;	√	√
COMPILE DATABASE	√		√
<database>	√		√
;	√
CREATE	√		√
CONNECTION  <ConnectionName>	√		√
[ [ DATASOURCE <cDataSourceName> ]	√		√
[ USERID <cUserID> ]	√		√
[ PASSWORD <cPassWord> ]	√		√
[ DATABASE <cDatabaseName> ]	√		√
<CONNSTRING cConnectionString > ]	√		√
CREATE	√	√
CURSOR <cursor>	√		√
( <column> <datatype> [ ( <precision> [, <scale> ] ) ]	√		√
[ NULL	√		√
NOT NULL ]	√		√
[ CHECK <expression>	√		√
[ ERROR <text> ] ]	√		√
[ AUTOINC	√		√
[ NEXTVALUE <NextValue>	√		√
[ STEP <StepValue> ] ] ]	√		√
[ DEFAULT <expression> ]	√		√
[ UNIQUE	√		√
[ COLLATE <cCollateSequence> ] ]	√		√
[ NOCPTRANS ]	√		√
[,  ...] )	√		√
;	√
CURSOR <cursor>	√		√
FROM ARRAY <ArrayName>	√		√
;	√
DATABASE <database>	√	√	√
[ IF NOT EXISTS ]	√	√
;	√	√
FUNCTION <function>		√
[ AGGREGATE ]		√
RETURNS {STRING|REAL|INTEGER}		√
SONAME <library>		√
;		√
INDEX <index>	√	√
[ UNIQUE ]	√	√
[ FULLTEXT ]		√
ON <table>	√	√
(<column>  [,...])	√	√
(<column>  [ ( length) ]  [,...])		√
[ASC | DESC]	√
;	√	√
DBF <table>	√		√
TABLE	√	√	√
[ <database>! ]	√
<table>	√	√	√
[ TEMPORARY ]		√
[ IF NOT EXISTS ]		√
[ NAME <LongTableName> ]	√		√
[ FREE ]	√		√
(<column> <datatype> [<constraint> <value> [...]][,...])	√	√	√
[TYPE = {		√
BDB		√
HEAP		√
ISAM		√
InnoDB		√
MERGE		√
MRG_MYISAM		√
MYISAM		√
CLIPPER	√
CLIPPER5	√
RECITAL	√
DBASE3	√
DBASE4	√
FOXPLUS	√
FOXPRO	√
VFP } ]	√
;	√	√
[FROM] XML <.xml file>	√
[LOAD]	√
;	√
SELECT <statement>		√
[IGNORE | REPLACE]		√
;	√	√
[ FROM ARRAY <array>]	√		√
;	√		√
TRIGGER	√		√
ON <table>	√		√
FOR	√		√
[ UPDATE	√		√
INSERT	√		√
DELETE ]	√		√
AS <exp>	√		√
;	√
[ SQL ]			√
VIEW <view>	√		√
[ REMOTE ]			√
[ CONNECTION ConnectionName			√
[ SHARE ]			√
CONNECTION DataSourceName ]			√
[(<alias> [,...])]	√
AS <sub-query>	√		√
;	√		√
DECLARE	√
<cursor>	√
[READ ONLY | INSERT ONLY]	√
[TABLE]	√
CURSOR FOR SELECT <statement>	√
;	√
DELETE	√	√	√
FROM	√	√
[ <database> ! ]	√		√
<table>	√	√	√
[ WHERE CURRENT OF <cursor> ]	√
[ WHERE CURRENT OF <condition> ]	√	√
[ WHERE <condition > ]	√		√
[ LOW_PRIORITY ]		√
[ QUICK ]		√
[ ORDER BY … ]		√
[ LIMIT rows ]		√
[ USING table-references ]		√
;	√	√
TRIGGER	√		√
ON <table>	√		√
FOR	√		√
[ UPDATE	√		√
INSERT	√		√
DELETE ]	√		√
;	√
DESCRIBE		√
<table>		√
[ <column>		√
<pattern> ]		√
;		√
DROP	√	√
CURSOR <cursor>	√
;	√
DATABASE <database>	√	√
[ IF EXISTS ]	√	√
;	√	√
FUNCTION <function>		√
;		√
INDEX <index>	√	√
ON <table>	√	√
;	√	√
TABLE	√	√
[ <database>! ]	√
<table>	√	√
[ IF EXISTS ]		√
[ RESTRICT ]		√
[ CASCADE ]		√
;	√	√
VIEW <view>	√
;	√		√
END	√		√
TRANSACTION	√
[ <transaction-name> ]	√
;	√
EXEC SQL	√
<SQL statement>	√
EXECUTE	√
IMMEDIATE <statement>	√
;	√
EXECUTE	√
<statement-name>	√
USING	√
:<variable> [ , :<variable>  [ , … ]  ]	√
;	√
EXPLAIN		√
<table>		√
;		√
SELECT <statement>		√
;		√
FETCH	√
[ NEXT ]	√
[ FIRST ]	√
[ PREVIOUS ]	√
[ LAST ]	√
[ ABSOLUTE <row position> ]	√
;	√
[ CURRENT ]	√
[ RELATIVE <row position>]	√
<cursor> INTO <data variable> [, ...]	√
;	√
XML <xml file>	√
;	√
GRANT	√	√
ALL	√	√
ON	√
[ <database>! ]	√
<table>	√	√
TO ‘<user>,<group>’ [,...]	√	√
PUBLIC	√	√
;	√	√
[ SELECT [ (<column> [,...] ) ] ]	√	√
[ UPDATE [ (<column> [,...] ) ] ]	√	√
[ INSERT ]	√	√
[ DELETE ]	√	√
[ ALTER ]	√	√
[ READ ONLY [ (<column> [,...] ) ] ]	√
[ CREATE TEMPORARY TABLES ]		√
[ CREATE ]		√
[ DROP ]		√
[ EXECUTE  ]		√
[ FILE ]		√
[ INDEX  ]		√
[ LOCK TABLES ]		√
[ PROCESS  ]		√
[ REPLICATION CLIENT ]		√
[ REPLICATION SLAVE ]		√
[ SHOW DATABASES ]		√
[ SUPER ]		√
ON	√	√
[ <database>! ]	√
<table>	√	√
TO ‘<user>,<group>’ [,...]	√	√
PUBLIC	√	√
;	√	√
INSERT	√	√	√
[ LOW_PRIORITY		√
DELAYED ]		√
[ IGNORE ]		√
INTO	√	√	√
[ <database>! ]	√		√
<table>	√	√	√
[(<column> [,...])]	√	√	√
VALUES(	√	√	√
<expr> [ , ]	√	√	√
DEFAULT [ , ]		√
NULL [ , ]	√	√
<empty> [ , ]	√
[,...] )	√	√	√
;	√	√
[ LOW_PRIORITY		√
DELAYED ]		√
[ IGNORE ]		√
INTO		√
[ <database>! ]
<table>		√
SET		√
<column>  = (		√
<expr> [ , ]		√
DEFAULT [ , ]		√
NULL [ , ]		√
<empty> [ , ]
[,...] )		√
;		√
[ LOW_PRIORITY		√
DELAYED ]		√
[ IGNORE ]		√
INTO	√	√	√
[ <database>! ]	√		√
<table>	√	√	√
[(<column> [,...])]	√	√	√
SELECT <sub-query>	√	√	√
;	√	√
[ LOW_PRIORITY
DELAYED ]
[ IGNORE ]
INTO	√
[ <database>! ]	√
<table>	√
[(<column> [,...])]	√
[FROM]	√
XML <.xml file>	√
;	√
INTO	√		√
[ <database>! ]	√		√
<table>	√	√	√
FROM ARRAY <ArrayName>	√		√
;	√
INTO	√		√
[ <database>! ]	√		√
<table>	√	√	√
FROM MEMVAR	√		√
;	√
INTO	√		√
[ <database>! ]	√		√
<table>	√	√	√
FROM NAME <ObjectName>	√		√
;	√
LOCK	√	√
TABLE	√	√
[ <database>! ]	√
<table>	√	√
AS <alias>		√
IN	√
SHARE	√
EXCLUSIVE MODE	√
[ NOWAIT ]	√
{ READ		√
[ READ LOCAL ]		√
[ LOW_PRIORITY ] WRITE }		√
;	√	√
OPEN	√
CURSOR <cursor>	√
;	√
DATABASE [<FileName> | <?>]	√		√
[EXCLUSIVE | SHARED]	√		√
[NOUPDATE]	√		√
[VALIDATE]	√		√
;	√
PREPARE	√
<statement>	√
FROM :<variable>	√
;	√
REVOKE	√	√
ALL	√	√
ON	√	√
[ <database>! ]	√
<table>	√	√
TO ‘<user>,<group>’ [,...]	√	√
PUBLIC	√	√
;	√	√
[ SELECT [ (<column> [,...] ) ] ]	√	√
[ UPDATE [ (<column> [,...] ) ] ]	√	√
[ INSERT ]	√	√
[ DELETE ]	√	√
[ ALTER ]	√	√
[ READ ONLY [ (<column> [,...] ) ] ]	√	√
[ CREATE TEMPORARY TABLES ]		√
[ CREATE ]		√
[ DROP ]		√
[ EXECUTE  ]		√
[ FILE ]		√
[ INDEX  ]		√
[ LOCK TABLES ]		√
[ PROCESS  ]		√
[ REPLICATION CLIENT ]		√
[ REPLICATION SLAVE ]		√
[ SHOW DATABASES ]		√
[ SUPER ]		√
ON	√	√
[ <database>! ]	√
<table>	√	√
TO ‘<user>,<group>’ [,...]	√	√
PUBLIC	√	√
;	√	√
ROLLBACK	√	√	√
[ TRANSACTION  <transaction-name> ]	√
[ WORK ]	√
[ TO SAVEPOINT <savepoint-name> ]	√
;	√	√
SAVE	√
[ TRANSACTION ]	√
<savepoint-name>	√
;	√
SAVEPOINT	√
<savepoint-name>	√
;	√
SELECT	√	√	√
[ ALL	√	√	√
DISTINCT	√	√	√
DISTINCTROW	√	√
TOP <rows>	√		√
[ PERCENT ] ]	√		√
[ STRAIGHT_JOIN ]		√
[ SQL_SMALL_RESULT ]		√
[ SQL_BIG_RESULT ]		√
[ SQL_BUFFER_RESULT ]		√
[ SQL_CACHE		√
SQL_NO_CACHE ]		√
[ SQL_CALC_FOUND_ROWS ]		√
[ HIGH_PRIORITY ]		√
*	√	√	√
[<t_alias>.]<column> [[ AS] <c_alias>]	√	√	√
[<"t_alias".]<"column">  [[ AS] <c_alias>]	√
<constant>  [[ AS] <c_alias>]	√	√	√
<function>  [[ AS] <c_alias>]	√	√	√
<aggregate>   [[ AS] <c_alias>]	√	√	√
[,  … ]	√	√	√
FROM	√		√
[ FORCE ]	√		√
[ <database!> ]	√		√
<table>	√		√
<view>	√		√
{ OJ <table>	√	√
[ LEFT	√	√
RIGHT	√	√
FULL ]	√	√
OUTER JOIN	√	√
[ <database!> ]	√		√
<table>	√	√
ON <exp>=<exp> }	√	√
[AS <t_alias> [, ...]]	√		√
[ INNER JOIN	√	√	√
OUTER JOIN	√	√	√
[ NATURAL ]		√
LEFT [OUTER] JOIN	√	√	√