Function	Recital	MySQL	VFP
ADATABASE(<array>)	√		√
AVG()	√	√	√
<expr>	√	√	√
<expr>	√	√
[ NOT ]	√	√
BETWEEN <expr>	√	√
AND <expr>	√	√
BITAND(<int1>,<in2> [,<int…>] )	√		√
BITCLEAR(<int1>,<int2>)	√		√
BITLSHIFT(<int1>,<int2>)	√		√
BITNOT(<int>)	√		√
BITOR(<int1>,<in2> [,<int…>] )	√		√
BITRSHIFT(<int1>,<int2>)	√		√
BITSET(<int1>,<int2>)	√		√
BITTEST(<int1>,<int2>)	√		√
BITXOR(<int1>,<in2> [,<int…>] )	√		√
BETWEEN(<exp1>,<exp2>,<exp3>)	√		√
CASE value WHEN		√
[compare-value]		√
THEN result		√
[WHEN [compare-value] THEN result ...]		√
[ELSE result]		√
END		√
CAST(<exp1> AS cDataType [(nFieldWidth [, nPrecision])])	√		√
[NULL | NOT NULL])	√		√
CDOW( <expD> | <expT> )	√		√
CMONTH( <expD> | <expT> )	√		√
COUNT()	√	√	√
*	√	√	√
DISTINCT <expr>	√	√
CTOT( < expC> )	√		√
CURSORSETPROP()			√
DATE( [ <Year>, <Month>, <Day> ] )	√		√
DATETIME( [ <Year>, <Month>, <Day>	√		√
[, <Hour> [, <Minute> [, <Second> ] ] ] ] )	√		√
DAY( <expD> | <expT> )	√		√
DBSETPROP()			√
DBUSED(<database>)	√		√
DOW( <expD> | <expT> , [ <expN> ] )	√		√
DMY( <expD> | <expT> )	√		√
DTOC( <expD> | <expT> , [ 1 ] )	√		√
DTOS( <expD> | <expT> )	√		√
EMPTY( <exp> )	√		√
GOMONTH( <expD> | <expT> , <expN> )	√		√
HOUR( <expT>)	√		√
HOURS( <expC> )	√
ICASE( lCondition1, eResult1 [, lCondition2, eResult2] …	√		√
[, eOtherwiseResult])	√		√
IF(<expr1>, <expr2>, <expr3>)	√	√
IIF(<expr1>, <expr2>, <expr3>)	√		√
<expr>	√	√
[NOT]	√	√
IN (<value list>)	√	√
<expr>	√
[ NOT ]	√
IN (<nested select>)	√
IS	√	√
[ NOT ]	√	√
NULL	√	√
ISNULL(<expr>)	√		√
<expr>	√	√
[ NOT ]	√	√
LIKE <expr>	√	√
LIKE(<expC1>, <expC2>)	√		√
MAX()	√	√	√
<expr>	√	√	√
MDY( <expD> | <expT> )	√		√
MIN()	√	√	√
<expr>	√	√	√
MINUTE( <expT>)	√		√
MINUTES( <expC> )	√
MONTH( <expD> | <expT> )	√		√
NVL(<exp1>,<exp2>)	√		√
QUARTER( <expD> | <expT> [ , <expN> ]  )	√		√
REFERENCES( )	√
<column>	√
<table>	√
[ <key> ]	√
SEC( <expT>)	√		√
SECS( <expC> )	√
SECONDS( )	√		√
SQLCANCEL( )	√		√
<nStatementHandle>	√		√
SQLCOLUMNS()	√		√
<nStatementHandle>	√		√
, <cTableName>	√		√
[, "FOXPRO" | "NATIVE"]	√		√
[, <cCursorName> ]	√		√
SQLCOMMIT()	√		√
<nStatementHandle>	√		√
SQLCONNECT()	√		√
[ <nStatementHandle> ]	√		√
[ <cConnectionName>	√		√
<cDataSourceName>	√		√
[ , <cUserID>	√		√
[ , <cPassword> ] ]	√		√
[ , <lShared> ] ]	√		√
SQLDISCONNECT()	√		√
<nStatementHandle>	√		√
SQLEXEC()	√		√
<nStatementHandle>	√		√
, <cSQLCommand>	√		√
,  [ <cCursorName> ]	√		√
SQLGETPROP()	√		√
<nStatementHandle>	√		√
, <cSetting>	√		√
SQLMORERESULTS()	√		√
<nStatementHandle>	√		√
SQLPREPARE()	√		√
<nStatementHandle>	√		√
, <cSQLCommand>	√		√
,  [ <cCursorName> ]	√		√
SQLROLLBACK()	√		√
<nStatementHandle>	√		√
SQLSETPROP()	√		√
<nStatementHandle>	√		√
, <cSetting>	√		√
[ , <eExpression> ]	√		√
SQLSTRINGCONNECT()	√		√
[ <lShared> ]	√		√
[ <cConnectString>	√		√
[, <lShared> ] ]	√		√
SQLTABLES()	√		√
<nStatementHandle>	√		√
[ , <cTableTypes> ]	√		√
[ , <cCursorName> ]	√		√
SQLVALUES()	√
<SQL statement>	√
SUM()	√	√	√
<expr>	√	√	√
TABLEREVERT()			√
TABLEUPDATE()			√
TIME( <expN> )	√		√
TTOC( < expT> [, 1 | 2])	√		√
TTOD( < expT> )	√		√
TXNISOLATION()	√
TXNLEVEL()	√		√
YEAR( <expD> | <expT> )	√		√
SQL Comparison Tables
Copyright © 2005 Recital Corporation. All rights reserved.
http://www.recital.com