| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] MACADDR datatype platform comparison PostgreSQL MAKE_REF function (Oracle) MAKE_SET function (MySQL) MASKLEN function (PostgreSQL) MAX function 2nd MD5 function (MySQL) MEDIAN function (Oracle) MEDIUMBLOB datatype MySQL platform comparison MEDIUMINT datatype MySQL MEDIUMTEXT datatype MySQL platform comparison MERGE statement DB2 keywords MySQL Oracle platform support for PostgreSQL programming tips quick reference rules SQL Server SQL2003 syntax metadata methods ADO.NET DataReader JDBC ResultSet MICROSECOND function (DB2) Microsoft SQL Server Microsoft SQL Server keywords MID function (MySQL) MIDNIGHT_SECONDS function (DB2) MIN function 2nd MINUTE function DB2 MySQL MOD function modula (%) arithmetic operator (SQLServer) MONEY datatype platform comparison PostgreSQL SQL Server MONTH function DB2 MySQL SQL Server MONTHNAME function DB2 MySQL MONTHS_BETWEEN function (Oracle) multiplication (*) arithmetic operator MULTIPLY_ALT function (DB2) MUT_EXCL_ROLES function MySQL allowed characters in identifiers ALTER TABLE syntax beginning identifier character CALL statement COMMIT statement connecting using JDBC CREATE/ALTER DATABASE statements CREATE/ALTER FUNCTION/PROCEDURE statements CREATE/ALTER INDEX statements CREATE/ALTER METHOD statements CREATE/ALTER ROLE statements CREATE/ALTER SCHEMA statements CREATE/ALTER TABLE keywords and parameters CREATE/ALTER TABLE statements ALTER ALTER COLUMN AUTO_INCREMENT AVG_ROW_LENGTH CHANGE CHECKSUM COMMENT constraint_type DATA DIRECTORY DELAY_KEY_WRITE DROP ENABLE KEYS IF NOT EXISTS IGNORE SELECT_statement INDEX DIRECTORY INSERT_METHOD keywords MAX_ROWS MIN_ROWS MODIFY PACK_KEYS parameters PASSWORD RAID_CHUNKS RAID_CHUNKSIZE RAID_TYPE RENAME REPLACE SELECT_statement ROW_FORMAT TEMPORARY TYPE CREATE/ALTER TRIGGER statements CREATE/ALTER TYPE statements CREATE/ALTER VIEW statements datatypes DECLARE CURSOR command DELETE statement DISCONNECT statement DROP statements EXCEPT set operator FETCH statement functions ,POW ACOS ADDDATE ASCII ASIN ATAN ATAN2 BENCHMARK BIN BINARY BIT_AND BIT_COUNT BIT_OR CHAR COALESCE COMPRESS CONCAT_WS CONNECTION_ID( ) CONV COS COT CURDATE( ) CURTIME( ) DATABASE( ) DATE_ FORMAT DATE_ADD DATE_SUB DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR DECODE DEGREES ELT ENCODE ENCRYPT EXPORT_SET FIELD FIND_IN_SET FORMAT FROM_DAYS FROM_UNIXTIME 2nd GET_LOCK GREATEST HEX HOUR IF IFNULL INSERT INSTR INTERVAL IS_FREE_LOCK ISNULL LAST_INSERT_ID LCASE LEAST LEFT LENGTH LOAD_FILE LOCATE LOG LOG10 LOG2 LPAD LTRIM MAKE_SET MD5 MID MINUTE MONTH MONTHNAME NOW( ) NULLIF OCT ORD PASSWORD PERIOD_ADD PERIOD_DIFF PI( ) POSITION POWER QUARTER RADIANS RAND( ) RELEASE_LOCK REPEAT REPLACE REVERSE RIGHT ROUND RPAD RTRIM SEC_TO_TIME SECOND SESSION_USER( ) SHA SHA1 SIGN SIN SOUNDEX SPACE STD STDDEV STRCMP SUBDATE SUBSTRING SUBSTRING_INDEX SYSDATE( ) SYSTEM_USER( ) TAN TIME_FORMAT TIME_TO_SEC TO_DAYS TRUNCATE UCASE UNCOMPRESS UNHEX UNIX_TIMESTAMP USER( ) VERSION( ) WEEK WEEKDAY YEAR YEARWEEK GRANT statement identifier size INSERT statement INTERSECT set operator JOIN subclause keywords LIKE operator MERGE statement OPEN statement ORDER BY clause RELEASE SAVEPOINT statement reserved identifiers RETURN statement REVOKE statement ROLLBACK statement SAVEPOINT statement schema addressing SELECT statement {FOR UPDATE LOCK IN SHARE MODE} FROM ‰ USE INDEX HIGH_PRIORITY IGNORE INDEX INTO JOIN syntax LIMIT PROCEDURE select_item SQL_BIG_RESULT SQL_BUFFER_RESULT SQL_SMALL_RESULT STRAIGHT_JOIN SET CONNECTION statement SET CONSTRAINT statement SET PATH statement SET ROLE statement SET SCHEMA statement SET SESSION AUTHORIZATION statement SET statement SET TIME ZONE statement SET TRANSACTION statement special rules START TRANSACTION statement SUBQUERY substatement TRUNCATE TABLE statement UNION set operator UPDATE statement web site WHERE clause |