· 8 years ago · Apr 13, 2018, 05:14 AM
1FUNCTIONS = %w(ABS ACOS ADDDATE ADDTIME AES_DECRYPT AES_ENCRYPT AREA ASCII ASIN ATAN ATAN2 AVG BENCHMARK BIN BIT_AND BIT_COUNT BIT_LENGTH BIT_OR BIT_XOR Boundary CAST CEIL CEILING CENTROID CHAR CHARACTER_LENGTH CHARSET CHAR_LENGTH COALESCE COERCIBILITY COLLATION COMPRESS CONCAT CONCAT_WS CONNECTION_ID CONV CONVERT CONVERT_TZ COS COT COUNT CRC32 CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURTIME DATABASE DATE DATEDIFF DATE_ADD DATE_DIFF DATE_FORMAT DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR DECODE DEFAULT DEGREES DES_DECRYPT DES_ENCRYPT DIMENSION ELT ENCODE ENCRYPT ENDPOINT ENVELOPE EXP EXPORT_SET EXTERIORRING EXTRACT FIELD FIND_IN_SET FLOOR FORMAT FOUND_ROWS FROM_DAYS FROM_UNIXTIME GEOMETRYN GEOMETRYTYPE GET_FORMAT GET_LOCK GLENGTH GREATEST GROUP_CONCAT GROUP_UNIQUE_USERS HEX HOUR IF IFNULL INET_ATON INET_NTOA INSERT INSTR INTERIORRINGN INTERVAL ISCLOSED ISEMPTY ISNULL ISRING ISSIMPLE IS_FREE_LOCK IS_USED_LOCK LAST_DAY LAST_INSERT_ID LCASE LEAST LEFT LENGTH LN LOAD_FILE LOCALTIME LOCALTIMESTAMP LOCATE LOG LOG10 LOG2 LOWER LPAD LTRIM MAKEDATE MAKETIME MAKE_SET MASTER_POS_WAIT MAX MD5 MICROSECOND MID MIN MINUTE MOD MONTH MONTHNAME NOW NULLIF NUMGEOMETRIES NUMINTERIORRINGS NUMPOINTS OCT OCTET_LENGTH OLD_PASSWORD ORD PASSWORD PERIOD_ADD PERIOD_DIFF PI POINTN POINTONSURFACE POSITION POW POWER QUARTER QUOTE RADIANS RAND RELEASE_LOCK REPEAT REPLACE REVERSE RIGHT ROUND ROW_COUNT RPAD RTRIM SCHEMA SECOND SEC_TO_TIME SESSION_USER SHA SHA1 SIGN SIN SLEEP SOUNDEX SPACE SQRT SRID STARTPOINT STD STDDEV STDDEV_POP STDDEV_SAMP STRCMP STR_TO_DATE SUBDATE SUBSTRING SUBSTRING_INDEX SUBTIME SUM SYSDATE SYSTEM_USER TAN TIME TIMEDIFF TIMESTAMP TIMESTAMPADD TIMESTAMPDIFF TIME_FORMAT TIME_TO_SEC TO_DAYS TRIM TRUNCATE UCASE UNCOMPRESS UNCOMPRESSED_LENGTH UNHEX UNIQUE_USERS UNIX_TIMESTAMP UPPER USER UTC_DATE UTC_TIME UTC_TIMESTAMP UUID VARIANCE VAR_POP VAR_SAMP VERSION WEEK WEEKDAY WEEKOFYEAR X Y YEAR YEARWEEK)
2 KEYWORDS = %w(ACTION ADD AFTER AGAINST AGGREGATE ALGORITHM ALL ALTER ANALYSE ANALYZE AND ARCHIVE AS ASC ASCII AUTOCOMMIT AUTO_INCREMENT AVG_ROW_LENGTH BACKUP BDB BEGIN BERKELEYDB BETWEEN BIGINT BINARY BINLOG BIT BLACKHOLE BLOB BOOL BOOLEAN BOTH BY CASCADE CASE CHANGE CHANGED CHAR CHARACTER CHARSET CHECK CHECKSUM CLIENT COLLATE COLLATION COLUMN COLUMNS COMMENT COMMIT COMMITTED COMPRESSED CONCURRENT CONSTRAINT CONVERT CREATE CROSS CSV CURRENT_TIMESTAMP DATA DATABASE DATABASES DATE DATETIME DAY DAY_HOUR DAY_MINUTE DAY_SECOND DEC DECIMAL DEFAULT DEFINER DELAYED DELAY_KEY_WRITE DELETE DESC DESCRIBE DISTINCT DISTINCTROW DIV DO DOUBLE DROP DUMPFILE DYNAMIC ELSE ENCLOSED END ENGINE ENGINES ENUM ESCAPE ESCAPED EVENTS EXAMPLE EXECUTE EXISTS EXPLAIN EXTENDED FAST FEDERATED FIELDS FILE FIRST FIXED FLOAT FLOAT4 FLOAT8 FLUSH FOR FORCE FOREIGN FROM FULL FULLTEXT FUNCTION GEMINI GEMINI_SPIN_RETRIES GLOBAL GRANT GRANTS GROUP HAVING HEAP HIGH_PRIORITY HOSTS HOUR HOUR_MINUTE HOUR_SECOND IDENTIFIED IF IGNORE IN INDEX INDEXES INFILE INNER INNOBASE INNODB INSERT INSERT_ID INSERT_METHOD INT INT1 INT2 INT3 INT4 INT8 INTEGER INTERVAL INTO IS ISAM ISOLATION JOIN KEY KEYS KILL LAST_INSERT_ID LEADING LEFT LEVEL LIKE LIMIT LINES LOAD LOCAL LOCK LOCKS LOGS LONG LONGBLOB LONGTEXT LOW_PRIORITY MASTER MASTER_CONNECT_RETRY MASTER_HOST MASTER_LOG_FILE MASTER_LOG_POS MASTER_PASSWORD MASTER_PORT MASTER_USER MATCH MAX_CONNECTIONS_PER_HOUR MAX_QUERIES_PER_HOUR MAX_ROWS MAX_UPDATES_PER_HOUR MAX_USER_CONNECTIONS MEDIUM MEDIUMBLOB MEDIUMINT MEDIUMTEXT MEMORY MERGE MIDDLEINT MINUTE MINUTE_SECOND MIN_ROWS MODE MODIFY MONTH MRG_ISAM MRG_MYISAM MYISAM NAMES NATIONAL NATURAL NCHAR NDB NDBCLUSTER NOT NULL NUMERIC OFFSET ON OPEN OPTIMIZE OPTION OPTIONALLY OR ORDER OUTER OUTFILE PACK_KEYS PARTIAL PASSWORD PRECISION PRIMARY PRIVILEGES PROCEDURE PROCESS PROCESSLIST PURGE QUICK RAID0 RAID_CHUNKS RAID_CHUNKSIZE RAID_TYPE READ REAL REFERENCES REGEXP RELOAD RENAME REPAIR REPEATABLE REPLACE REPLICATION RESET RESTORE RESTRICT RETURN RETURNS REVOKE RIGHT RLIKE ROLLBACK ROW ROWS ROW_FORMAT SECOND SELECT SEPARATOR SERIAL SERIALIZABLE SESSION SET SHARE SHOW SHUTDOWN SLAVE SMALLINT SONAME SOUNDS SQL_AUTO_IS_NULL SQL_BIG_RESULT SQL_BIG_SELECTS SQL_BIG_TABLES SQL_BUFFER_RESULT SQL_CACHE SQL_CALC_FOUND_ROWS SQL_LOG_BIN SQL_LOG_OFF SQL_LOG_UPDATE SQL_LOW_PRIORITY_UPDATES SQL_MAX_JOIN_SIZE SQL_NO_CACHE SQL_QUOTE_SHOW_CREATE SQL_SAFE_UPDATES SQL_SELECT_LIMIT SQL_SLAVE_SKIP_COUNTER SQL_SMALL_RESULT SQL_WARNINGS START STARTING STATUS STOP STORAGE STRAIGHT_JOIN STRING STRIPED SUPER TABLE TABLES TEMPORARY TERMINATED TEXT THEN TIME TIMESTAMP TINYBLOB TINYINT TINYTEXT TO TRAILING TRUNCATE TYPE TYPES UNCOMMITTED UNDEFINED UNICODE UNION UNIQUE UNLOCK UNSIGNED UPDATE USAGE USE USING VALUES VARBINARY VARCHAR VARIABLES VARYING VIEW WHEN WHERE WITH WORK WRITE XOR YEAR YEAR_MONTH ZEROFILL)