core_keywords ACCESSIBLE ACTION ADD AFTER AGAINST AGGREGATE ALGORITHM ALL ALTER ALTER COLUMN ALTER DATABASE ALTER EVENT ALTER FUNCTION ALTER LOGFILE GROUP ALTER PROCEDURE ALTER SCHEMA ALTER SERVER ALTER TABLE ALTER TABLESPACE ALTER VIEW ANALYZE ANALYZE TABLE AND ANY AS ASC ASCII ASENSITIVE AT AUTHORS AUTOEXTEND_SIZE AUTO_INCREMENT AVG AVG_ROW_LENGTH BACKUP BACKUP TABLE BEFORE BEGIN BETWEEN BIGINT BINARY BINLOG BIT BLOB BOOL BOOLEAN BOTH BTREE BY BYTE CACHE CACHE INDEX CALL CASCADE CASCADED CASE CHAIN CHANGE CHANGED CHAR CHARACTER CHARACTER SET CHARSET CHECK CHECK TABLE CHECKSUM CHECKSUM TABLE CIPHER CLIENT CLOSE COALESCE CODE COLLATE COLLATION COLUMN COLUMNS COLUMN_FORMAT COMMENT COMMIT COMMITTED COMPACT COMPLETION COMPRESSED CONCURRENT CONDITION CONNECTION CONSISTENT CONSTRAINT CONTAINS CONTINUE CONTRIBUTORS CONVERT CREATE CREATE DATABASE CREATE EVENT CREATE FUNCTION CREATE INDEX CREATE LOGFILE GROUP CREATE PROCEDURE CREATE SCHEMA CREATE TABLE CREATE TABLESPACE CREATE TRIGGER CREATE USER CREATE VIEW CROSS CUBE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR DATA DATABASE DATABASES DATAFILE DATE DATETIME DAY DAY_HOUR DAY_MICROSECOND DAY_MINUTE DAY_SECOND DEALLOCATE DEALLOCATE PREPARE DEC DECIMAL DECLARE DEFAULT DEFINER DELAYED DELAY_KEY_WRITE DELETE DELIMITER DELIMITER ;\n DELIMITER ;;\n DESC DESCRIBE DES_KEY_FILE DETERMINISTIC DIRECTORY DISABLE DISCARD DISK DISTINCT DISTINCTROW DIV DO DOUBLE DROP DROP DATABASE DROP EVENT DROP FOREIGN KEY DROP FUNCTION DROP INDEX DROP LOGFILE GROUP DROP PREPARE DROP PRIMARY KEY DROP PREPARE DROP PROCEDURE DROP SCHEMA DROP SERVER DROP TABLE DROP TABLESPACE DROP TRIGGER DROP USER DROP VIEW DUAL DUMPFILE DUPLICATE DYNAMIC EACH ELSE ELSEIF ENABLE ENCLOSED END ENDS ENGINE ENGINES ENUM ERRORS ESCAPE ESCAPED EVENT EVENTS EVERY EXECUTE EXISTS EXIT EXPANSION EXPLAIN EXTENDED EXTENT_SIZE FALSE FAST FETCH FIELDS FIELDS TERMINATED BY FILE FIRST FIXED FLOAT FLOAT4 FLOAT8 FLUSH FOR FOR UPDATE FORCE FOREIGN FOREIGN KEY FOUND FRAC_SECOND FROM FULL FULLTEXT FUNCTION GEOMETRY GEOMETRYCOLLECTION GLOBAL GRANT GRANTS GROUP GROUP BY HANDLER HASH HAVING HELP HIGH_PRIORITY HOSTS HOUR HOUR_MICROSECOND HOUR_MINUTE HOUR_SECOND IDENTIFIED IF IGNORE IMPORT IN INDEX INDEXES INFILE INITIAL_SIZE INNER INNOBASE INNODB INOUT INSENSITIVE INSERT INSERT_METHOD INSTALL INSTALL PLUGIN INT INT1 INT2 INT3 INT4 INT8 INTEGER INTERVAL INTO INTO DUMPFILE INTO OUTFILE INTO TABLE INVOKER IO_THREAD IS ISOLATION ISSUER ITERATE JOIN KEY KEYS KEY_BLOCK_SIZE KILL LANGUAGE LAST LEADING LEAVE LEAVES LEFT LESS LEVEL LIKE LIMIT LINEAR LINES LINES TERMINATED BY LINESTRING LIST LOAD DATA LOAD INDEX INTO CACHE LOAD XML LOCAL LOCALTIME LOCALTIMESTAMP LOCK LOCK IN SHARE MODE LOCK TABLES LOCKS LOGFILE LOGS LONG LONGBLOB LONGTEXT LOOP LOW_PRIORITY MASTER MASTER_CONNECT_RETRY MASTER_HOST MASTER_LOG_FILE MASTER_LOG_POS MASTER_PASSWORD MASTER_PORT MASTER_SERVER_ID MASTER_SSL MASTER_SSL_CA MASTER_SSL_CAPATH MASTER_SSL_CERT MASTER_SSL_CIPHER MASTER_SSL_KEY MASTER_USER MATCH MAXVALUE MAX_CONNECTIONS_PER_HOUR MAX_QUERIES_PER_HOUR MAX_ROWS MAX_SIZE MAX_UPDATES_PER_HOUR MAX_USER_CONNECTIONS MEDIUM MEDIUMBLOB MEDIUMINT MEDIUMTEXT MEMORY MERGE MICROSECOND MIDDLEINT MIGRATE MINUTE MINUTE_MICROSECOND MINUTE_SECOND MIN_ROWS MOD MODE MODIFIES MODIFY MONTH MULTILINESTRING MULTIPOINT MULTIPOLYGON MUTEX NAME NAMES NATIONAL NATURAL NCHAR NDB NDBCLUSTER NEW NEXT NO NODEGROUP NONE NOT NO_WAIT NO_WRITE_TO_BINLOG NULL NUMERIC NVARCHAR OFFSET OLD_PASSWORD ON ONE ONE_SHOT OPEN OPTIMIZE OPTIMIZE TABLE OPTION OPTIONALLY OPTIONALLY ENCLOSED BY OPTIONS OR ORDER ORDER BY OUT OUTER OUTFILE PACK_KEYS PARSER PARTIAL PARTITION PARTITIONING PARTITIONS PASSWORD PHASE PLUGIN PLUGINS POINT POLYGON PRECISION PREPARE PRESERVE PREV PRIMARY PRIMARY KEY PRIVILEGES PROCEDURE PROCEDURE ANALYSE PROCESS PROCESSLIST PURGE QUARTER QUERY QUICK RANGE READ READS READ_ONLY READ_WRITE REAL REBUILD RECOVER REDOFILE REDO_BUFFER_SIZE REDUNDANT REFERENCES REGEXP RELAY_LOG_FILE RELAY_LOG_POS RELAY_THREAD RELEASE RELOAD REMOVE RENAME RENAME DATABASE RENAME TABLE REORGANIZE REPAIR REPAIR TABLE REPEAT REPEATABLE REPLACE REPLICATION REQUIRE RESET RESET MASTER RESTORE RESTORE TABLE RESTRICT RESUME RETURN RETURNS REVOKE RIGHT RLIKE ROLLBACK ROLLUP ROUTINE ROW ROWS ROWS IDENTIFIED BY ROW_FORMAT RTREE SAVEPOINT SCHEDULE SCHEDULER SCHEMA SCHEMAS SECOND SECOND_MICROSECOND SECURITY SELECT SELECT DISTINCT SENSITIVE SEPARATOR SERIAL SERIALIZABLE SESSION SET SET GLOBAL SET NAMES SET PASSWORD SHARE SHOW SHOW BINARY LOGS SHOW BINLOG EVENTS SHOW CHARACTER SET SHOW COLLATION SHOW COLUMNS SHOW CONTRIBUTORS SHOW CREATE DATABASE SHOW CREATE EVENT SHOW CREATE FUNCTION SHOW CREATE PROCEDURE SHOW CREATE SCHEMA SHOW CREATE TABLE SHOW CREATE TRIGGERS SHOW CREATE VIEW SHOW DATABASES SHOW ENGINE SHOW ENGINES SHOW ERRORS SHOW EVENTS SHOW FIELDS SHOW FULL PROCESSLIST SHOW FUNCTION CODE SHOW FUNCTION STATUS SHOW GRANTS SHOW INDEX SHOW INNODB STATUS SHOW KEYS SHOW MASTER LOGS SHOW MASTER STATUS SHOW OPEN TABLES SHOW PLUGINS SHOW PRIVILEGES SHOW PROCEDURE CODE SHOW PROCEDURE STATUS SHOW PROFILE SHOW PROFILES SHOW PROCESSLIST SHOW SCHEDULER STATUS SHOW SCHEMAS SHOW SLAVE HOSTS SHOW SLAVE STATUS SHOW STATUS SHOW STORAGE ENGINES SHOW TABLE STATUS SHOW TABLE TYPES SHOW TABLES SHOW TRIGGERS SHOW VARIABLES SHOW WARNINGS SHUTDOWN SIGNED SIMPLE SLAVE SMALLINT SNAPSHOT SOME SONAME SOUNDS SPATIAL SPECIFIC 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_THREAD SQL_TSI_DAY SQL_TSI_FRAC_SECOND SQL_TSI_HOUR SQL_TSI_MINUTE SQL_TSI_MONTH SQL_TSI_QUARTER SQL_TSI_SECOND SQL_TSI_WEEK SQL_TSI_YEAR SQL_WARNINGS SSL START START TRANSACTION STARTING STARTS STATUS STOP STORAGE STRAIGHT_JOIN STRING SUBJECT SUBPARTITION SUBPARTITIONS SUPER SUSPEND TABLE TABLES TABLESPACE TEMPORARY TEMPTABLE TERMINATED TEXT THAN THEN TIME TIMESTAMP TIMESTAMPADD TIMESTAMPDIFF TINYBLOB TINYINT TINYTEXT TO TRAILING TRANSACTION TRIGGER TRIGGERS TRUE TRUNCATE TYPE TYPES UNCOMMITTED UNDEFINED UNDO UNDOFILE UNDO_BUFFER_SIZE UNICODE UNINSTALL UNINSTALL PLUGIN UNION UNIQUE UNKNOWN UNLOCK UNLOCK TABLES UNSIGNED UNTIL UPDATE UPGRADE USAGE USE USER USER_RESOURCES USE_FRM USING UTC_DATE UTC_TIME UTC_TIMESTAMP VALUE VALUES VARBINARY VARCHAR VARCHARACTER VARIABLES VARYING VIEW WAIT WARNINGS WEEK WHEN WHERE WHILE WITH WITH CONSISTENT SNAPSHOT WORK WRITE X509 XA XOR YEAR YEAR_MONTH ZEROFILL core_builtin_functions ABS ACOS ADDDATE ADDTIME AES_DECRYPT AES_ENCRYPT AREA ASBINARY ASCII ASIN ASTEXT ATAN ATAN2 AVG BDMPOLYFROMTEXT BDMPOLYFROMWKB BDPOLYFROMTEXT BDPOLYFROMWKB BENCHMARK BIN BIT_AND BIT_COUNT BIT_LENGTH BIT_OR BIT_XOR BOUNDARY BUFFER CAST CEIL CEILING CENTROID CHAR CHARACTER_LENGTH CHARSET CHAR_LENGTH COALESCE COERCIBILITY COLLATION COMPRESS CONCAT CONCAT_WS CONNECTION_ID CONTAINS CONV CONVERT CONVERT_TZ CONVEXHULL COS COT COUNT COUNT(*) CRC32 CROSSES 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 DIFFERENCE DIMENSION DISJOINT DISTANCE ELT ENCODE ENCRYPT ENDPOINT ENVELOPE EQUALS EXP EXPORT_SET EXTERIORRING EXTRACT EXTRACTVALUE FIELD FIND_IN_SET FLOOR FORMAT FOUND_ROWS FROM_DAYS FROM_UNIXTIME GEOMCOLLFROMTEXT GEOMCOLLFROMWKB GEOMETRYCOLLECTION GEOMETRYCOLLECTIONFROMTEXT GEOMETRYCOLLECTIONFROMWKB GEOMETRYFROMTEXT GEOMETRYFROMWKB GEOMETRYN GEOMETRYTYPE GEOMFROMTEXT GEOMFROMWKB GET_FORMAT GET_LOCK GLENGTH GREATEST GROUP_CONCAT GROUP_UNIQUE_USERS HEX HOUR IF IFNULL INET_ATON INET_NTOA INSERT INSERT_ID INSTR INTERIORRINGN INTERSECTION INTERSECTS INTERVAL ISCLOSED ISEMPTY ISNULL ISRING ISSIMPLE IS_FREE_LOCK IS_USED_LOCK LAST_DAY LAST_INSERT_ID LCASE LEAST LEFT LENGTH LINEFROMTEXT LINEFROMWKB LINESTRING LINESTRINGFROMTEXT LINESTRINGFROMWKB LN LOAD_FILE LOCALTIME LOCALTIMESTAMP LOCATE LOG LOG10 LOG2 LOWER LPAD LTRIM MAKEDATE MAKETIME MAKE_SET MASTER_POS_WAIT MATCH MAX MBRCONTAINS MBRDISJOINT MBREQUAL MBRINTERSECTS MBROVERLAPS MBRTOUCHES MBRWITHIN MD5 MICROSECOND MID MIN MINUTE MLINEFROMTEXT MLINEFROMWKB MOD MONTH MONTHNAME NOW MPOINTFROMTEXT MPOINTFROMWKB MPOLYFROMTEXT MPOLYFROMWKB MULTILINESTRING MULTILINESTRINGFROMTEXT MULTILINESTRINGFROMWKB MULTIPOINT MULTIPOINTFROMTEXT MULTIPOINTFROMWKB MULTIPOLYGON MULTIPOLYGONFROMTEXT MULTIPOLYGONFROMWKB NAME_CONST NOW NULLIF NUMGEOMETRIES NUMINTERIORRINGS NUMPOINTS OCT OCTET_LENGTH OLD_PASSWORD ORD OVERLAPS PASSWORD PERIOD_ADD PERIOD_DIFF PI POINT POINTFROMTEXT POINTFROMWKB POINTN POINTONSURFACE POLYFROMTEXT POLYFROMWKB POLYGON POLYGONFROMTEXT POLYGONFROMWKB POSITION POW POWER QUARTER QUOTE RADIANS RAND RELATED 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 SUBSTR SUBSTRING SUBSTRING_INDEX SUBTIME SUM SYMDIFFERENCE SYSDATE SYSTEM_USER TAN TIME TIMEDIFF TIMESTAMP TIMESTAMPADD TIMESTAMPDIFF TIME_FORMAT TIME_TO_SEC TOUCHES TO_DAYS TRIM TRUNCATE UCASE UNCOMPRESS UNCOMPRESSED_LENGTH UNHEX UNIQUE_USERS UNIX_TIMESTAMP UPDATEXML UPPER USER UTC_DATE UTC_TIME UTC_TIMESTAMP UUID VARIANCE VAR_POP VAR_SAMP VERSION WEEK WEEKDAY WEEKOFYEAR WITHIN YEAR YEARWEEK function_argument_snippets CONCAT ${1:str1}, ${2:str2} CHAR ${1:N}, ${2:USING ${3:charset_name}} MASTER_POS_WAIT ${1:log_name}, ${2:log_pos}${3:, ${4:timeout}} WEEK ${1:date}${2:, ${3:mode}} UpdateXML ${1:xml_target}, ${2:xpath_expr}, ${3:new_xml} MID ${1:str}, ${2:pos}, ${3:len} ROUND ${1:X}${2:, ${3:D}} NULLIF ${1:expr1}, ${2:expr2} TIMEDIFF ${1:expr1}, ${2:expr2} REPLACE ${1:str}, ${2:from_str}, ${3:to_str} ADDTIME ${1:expr1}, ${2:expr2} TIMESTAMPDIFF ${1:unit}, ${2:datetime_expr1}, ${3:datetime_expr2} FROM_UNIXTIME ${1:unix_timestamp}${2:, ${3:format}} IFNULL ${1:expr1}, ${2:expr2} LEAST ${1:value1}, ${2:value2} MATCH ${1:col_list} AGAINST ${2:expr}${3: ${4:¦IN BOOLEAN MODE¦IN NATURAL LANGUAGE MODE¦IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION¦WITH QUERY EXPANSION¦}} DES_DECRYPT ${1:crypt_str}${2:, ${3:key_str}} DECODE ${1:crypt_str}, ${2:pass_str} GET_LOCK ${1:st}, ${2:timeout} CONV ${1:N}, ${2:from_base}, ${3:to_base} ENCRYPT ${1:str}${2:, ${3:salt}} ExtractValue ${1:xml_frag}, ${2:xpath_expr} FORMAT ${1:X}, ${2:D} TIME_FORMAT ${1:time}, ${2:format} LEFT ${1:str}, ${2:len RAND ${1:N} RPAD ${1:str}, ${2:len}, ${3:padstr} ELT ${1:N}, ${2:str1} CONCAT_WS ${1:separator}, ${2:str1} LOCATE ${1:substr}, ${2:str}${3:, ${4:pos}} SUBDATE ${1:date/expr}, ${2:INTERVAL ${3:expr} ${4:unit}} LPAD ${1:str}, ${2:len}, ${3:padstr} ANALYSE ${1:${2:max_elements}${3:, ${4:max_memory}}} TIMESTAMP ${1:expr1}${2:, ${3:expr2}} INSERT ${1:str}, ${2:pos}, ${3:len}, ${4:newstr} YEARWEEK ${1:date}${2:, ${3:mode}} UNIX_TIMESTAMP ${1:date} CONVERT ${1:expr}${2:, USING ${3:transcoding_name}} ADDDATE ${1:date/expr}${2:, INTERVAL ${3:expr} ${4:unit}} LAST_INSERT_ID ${1:expr} SUBTIME ${1:expr1}, ${2:expr2} POW ${1:X}, ${2:Y} INSTR ${1:str}, ${2:substr} REPEAT ${1:str}, ${2:count} MAKEDATE ${1:year}, ${2:dayofyear} SUBSTRING_INDEX ${1:str}, ${2:delim}, ${3:count} ENCODE ${1:str}, ${2:pass_str} TRUNCATE ${1:X}, ${2:D} TIMESTAMPADD ${1:unit}, ${2:interval}, ${3:datetime_expr} GREATEST ${1:value1}, ${2:value2} ATAN ${1:Y}, ${2:X} ATAN2 ${1:Y}, ${2:X} DATE_FORMAT ${1:date}, ${2:format} BENCHMARK ${1:count}, ${2:expr} NAME_CONST ${1:name}, ${2:value} CONVERT_TZ ${1:dt}, ${2:from_tz}, ${3:to_tz} EXPORT_SET ${1:bits}, ${2:on}, ${3:off}${4:, ${5:separator}${6:, ${7:number_of_bits}}} DATE_ADD ${1:date}, INTERVAL ${2:expr} ${3:unit} DATE_SUB ${1:date}, INTERVAL ${2:expr} ${3:unit} PERIOD_DIFF ${1:P1}, ${2:P2} DES_ENCRYPT ${1:str}${2:, ${3:¦key_num¦key_str¦}} STR_TO_DATE ${1:str}, ${2:format} DATE_SUB ${1:date}, INTERVAL ${2:expr} ${3:unit} PERIOD_ADD ${1:P}, ${2:N} RIGHT ${1:str}, ${2:len} DATEDIFF ${1:expr1}, ${2:expr2} COUNT ${1:${2:DISTINCT }${3:*}} INTERVAL ${1:N}, ${2:N1} AES_ENCRYPT ${1:str}, ${2:key_str} GET_FORMAT ${1:¦DATE¦TIME¦DATETIME¦}, ${2:¦'EUR'¦'USA'¦'JIS'¦'ISO'¦'INTERNAL'¦} FIELD ${1:str}, ${2:str1} MAKETIME ${1:hour}, ${2:minute}, ${3:second} IF ${1:test}, ${2:true_expr}, ${3:false_expr} POWER ${1:X}, ${2:Y} STRCMP ${1:expr1}, ${2:expr2} LOG ${1:B}, ${2:X} AES_DECRYPT ${1:crypt_str}, ${2:key_str} COALESCE ${1:values} MAKE_SET ${1:bits}, ${2:str1} FIND_IN_SET ${1:str}, ${2:strlist}