Hi
looking at todays changes, I also looked at MySQL reserved words (http://www.mysql.com/doc/en/Reserved_words.html). There are only 206 of them, while we have 248 in sqlparser.data.php3. Okay to strip them down to these from web?
Hi again
The diff is quite huge (- = in our list and not on web, + = listed on web and not it our list):
-ACTION -AFTER -AGAINST -AGGREGATE -ANALYSE -AUTOCOMMIT -AVG_ROW_LENGTH -BACKUP -BEGIN +ASENSITIVE +AUTO_INCREMENT +BDB +BEFORE +BERKELEYDB +BIGINT +BINARY +BLOB +BTREE +CALL -CHANGED +CHAR +CHARACTER -CHECKSUM -CLIENT +COLLATE -COMMENT -COMMIT -COMMITTED -COMPRESSED -CONCURRENT +CONNECTION -DATA +CURRENT_DATE +CURRENT_TIME +CURRENT_TIMESTAMP +CURSOR -DAY +DEC +DECIMAL +DECLARE +DEFAULT -DELAY_KEY_WRITE -DO +DIV +DOUBLE -DUMPFILE -DYNAMIC +ELSEIF -END -ESCAPE +ERRORS -EXECUTE -EXTENDED -FAST +FALSE -FILE -FIRST -FIXED -FLUSH +FLOAT +FORCE -FULL -FUNCTION -GEMINI -GEMINI_SPIN_RETRIES -GLOBAL -GRANTS +HASH -HEAP -HOSTS -HOUR -IDENTIFIED -INDEXES +INNODB +INOUT +INSENSITIVE -INSERT_ID -INSERT_METHOD +INT +INTEGER -ISOLATION +ITERATE -LAST_INSERT_ID +LEAVE -LEVEL -LOCAL +LOCALTIME +LOCALTIMESTAMP -LOCKS -LOGS +LONG +LONGBLOB +LONGTEXT +LOOP -MASTER -MASTER_CONNECT_RETRY -MASTER_HOST -MASTER_LOG_FILE -MASTER_LOG_POS -MASTER_PASSWORD -MASTER_PORT -MASTER_USER +MASTER_SERVER_ID -MAX_CONNECTIONS_PER_HOUR -MAX_QUERIES_PER_HOUR -MAX_ROWS -MAX_UPDATES_PER_HOUR -MEDIUM -MERGE -MIN_ROWS -MINUTE +MEDIUMBLOB +MEDIUMINT +MEDIUMTEXT +MIDDLEINT -MODE -MODIFY -MONTH +MOD -MYISAM -NO -NO +NUMERIC -OPEN +OUT -PACK_KEYS -PARTIAL -PASSWORD +PRECISION -PROCESS -PROCESSLIST -QUICK -RAID0 -RAID_CHUNKS -RAID_CHUNKSIZE -RAID_TYPE +REAL -RELOAD -REPAIR -REPEATABLE +REPEAT -REPLICATION -RESET -RESTORE +REQUIRE +RETURN -ROLLBACK -ROW -ROW_FORMAT -ROWS -SECOND +RTREE -SERIALIZABLE -SESSION -SHARE +SENSITIVE +SEPARATOR +SET -SHUTDOWN -SLAVE +SMALLINT +SOME -SQL_AUTO_IS_NULL +SPATIAL +SPECIFIC -SQL_BIG_SELECTS -SQL_BIG_TABLES -SQL_BUFFER_RESULT -SQL_LOG_BIN -SQL_LOG_OFF -SQL_LOG_UPDATE -SQL_LOW_PRIORITY_UPDATES -SQL_MAX_JOIN_SIZE -SQL_QUOTE_SHOW_CREATE -SQL_SAFE_UPDATES -SQL_SELECT_LIMIT -SQL_SLAVE_SKIP_COUNTER +SQL_CALC_FOUND_ROWS -SQL_WARNINGS -START +SSL -STATUS -STOP -STRING -SUPER -TEMPORARY +TINYBLOB +TINYINT +TINYTEXT -TRUNCATE -TYPE -UNCOMMITTED +TRUE +TYPES +UNSIGNED +UNTIL +USER_RESOURCES -VARIABLES +VARBINARY +VARCHAR +VARCHARACTER +VARYING +WARNINGS +WHILE -WORK +ZEROFILL