A quick question, what is your opinion on non-reserved keywords ? Should they be included, excluded, separated ? non-reserved words are acceptable and do not get in the way of your queries.
-Thadeus On Thu, Feb 4, 2010 at 9:18 PM, Thadeus Burgess <thade...@thadeusb.com> wrote: > I have firebird, and now mysql 5.5 > > -Thadeus > > > > > > On Thu, Feb 4, 2010 at 9:14 PM, Jonathan Lundell <jlund...@pobox.com> wrote: >> On Feb 4, 2010, at 7:03 PM, Thadeus Burgess wrote: >> >>> Yes, there is much work to be done formatting each one of those lists >>> into a python tuple object. >> >> That part isn't so bad. I need to know which ones you want. Here's MySQL 5.5: >> >> 'ACCESSIBLE', >> 'ADD', >> 'ALL', >> 'ALTER', >> 'ANALYZE', >> 'AND', >> 'AS', >> 'ASC', >> 'ASENSITIVE', >> 'BEFORE', >> 'BETWEEN', >> 'BIGINT', >> 'BINARY', >> 'BLOB', >> 'BOTH', >> 'BY', >> 'CALL', >> 'CASCADE', >> 'CASE', >> 'CHANGE', >> 'CHAR', >> 'CHARACTER', >> 'CHECK', >> 'COLLATE', >> 'COLUMN', >> 'CONDITION', >> 'CONSTRAINT', >> 'CONTINUE', >> 'CONVERT', >> 'CREATE', >> 'CROSS', >> 'CURRENT_DATE', >> 'CURRENT_TIME', >> 'CURRENT_TIMESTAMP', >> 'CURRENT_USER', >> 'CURSOR', >> 'DATABASE', >> 'DATABASES', >> 'DAY_HOUR', >> 'DAY_MICROSECOND', >> 'DAY_MINUTE', >> 'DAY_SECOND', >> 'DEC', >> 'DECIMAL', >> 'DECLARE', >> 'DEFAULT', >> 'DELAYED', >> 'DELETE', >> 'DESC', >> 'DESCRIBE', >> 'DETERMINISTIC', >> 'DISTINCT', >> 'DISTINCTROW', >> 'DIV', >> 'DOUBLE', >> 'DROP', >> 'DUAL', >> 'EACH', >> 'ELSE', >> 'ELSEIF', >> 'ENCLOSED', >> 'ESCAPED', >> 'EXISTS', >> 'EXIT', >> 'EXPLAIN', >> 'FALSE', >> 'FETCH', >> 'FLOAT', >> 'FLOAT4', >> 'FLOAT8', >> 'FOR', >> 'FORCE', >> 'FOREIGN', >> 'FROM', >> 'FULLTEXT', >> 'GRANT', >> 'GROUP', >> 'HAVING', >> 'HIGH_PRIORITY', >> 'HOUR_MICROSECOND', >> 'HOUR_MINUTE', >> 'HOUR_SECOND', >> 'IF', >> 'IGNORE', >> 'IGNORE_SERVER_IDS', >> 'IGNORE_SERVER_IDS', >> 'IN', >> 'INDEX', >> 'INFILE', >> 'INNER', >> 'INOUT', >> 'INSENSITIVE', >> 'INSERT', >> 'INT', >> 'INT1', >> 'INT2', >> 'INT3', >> 'INT4', >> 'INT8', >> 'INTEGER', >> 'INTERVAL', >> 'INTO', >> 'IS', >> 'ITERATE', >> 'JOIN', >> 'KEY', >> 'KEYS', >> 'KILL', >> 'LEADING', >> 'LEAVE', >> 'LEFT', >> 'LIKE', >> 'LIMIT', >> 'LINEAR', >> 'LINES', >> 'LOAD', >> 'LOCALTIME', >> 'LOCALTIMESTAMP', >> 'LOCK', >> 'LONG', >> 'LONGBLOB', >> 'LONGTEXT', >> 'LOOP', >> 'LOW_PRIORITY', >> 'MASTER_HEARTBEAT_PERIOD', >> 'MASTER_HEARTBEAT_PERIOD', >> 'MASTER_SSL_VERIFY_SERVER_CERT', >> 'MATCH', >> 'MAXVALUE', >> 'MAXVALUE', >> 'MEDIUMBLOB', >> 'MEDIUMINT', >> 'MEDIUMTEXT', >> 'MIDDLEINT', >> 'MINUTE_MICROSECOND', >> 'MINUTE_SECOND', >> 'MOD', >> 'MODIFIES', >> 'NATURAL', >> 'NO_WRITE_TO_BINLOG', >> 'NOT', >> 'NULL', >> 'NUMERIC', >> 'ON', >> 'OPTIMIZE', >> 'OPTION', >> 'OPTIONALLY', >> 'OR', >> 'ORDER', >> 'OUT', >> 'OUTER', >> 'OUTFILE', >> 'PRECISION', >> 'PRIMARY', >> 'PROCEDURE', >> 'PURGE', >> 'RANGE', >> 'READ', >> 'READ_WRITE', >> 'READS', >> 'REAL', >> 'REFERENCES', >> 'REGEXP', >> 'RELEASE', >> 'RENAME', >> 'REPEAT', >> 'REPLACE', >> 'REQUIRE', >> 'RESIGNAL', >> 'RESIGNAL', >> 'RESTRICT', >> 'RETURN', >> 'REVOKE', >> 'RIGHT', >> 'RLIKE', >> 'SCHEMA', >> 'SCHEMAS', >> 'SECOND_MICROSECOND', >> 'SELECT', >> 'SENSITIVE', >> 'SEPARATOR', >> 'SET', >> 'SHOW', >> 'SIGNAL', >> 'SIGNAL', >> 'SMALLINT', >> 'SPATIAL', >> 'SPECIFIC', >> 'SQL', >> 'SQL_BIG_RESULT', >> 'SQL_CALC_FOUND_ROWS', >> 'SQL_SMALL_RESULT', >> 'SQLEXCEPTION', >> 'SQLSTATE', >> 'SQLWARNING', >> 'SSL', >> 'STARTING', >> 'STRAIGHT_JOIN', >> 'TABLE', >> 'TERMINATED', >> 'THEN', >> 'TINYBLOB', >> 'TINYINT', >> 'TINYTEXT', >> 'TO', >> 'TRAILING', >> 'TRIGGER', >> 'TRUE', >> 'UNDO', >> 'UNION', >> 'UNIQUE', >> 'UNLOCK', >> 'UNSIGNED', >> 'UPDATE', >> 'USAGE', >> 'USE', >> 'USING', >> 'UTC_DATE', >> 'UTC_TIME', >> 'UTC_TIMESTAMP', >> 'VALUES', >> 'VARBINARY', >> 'VARCHAR', >> 'VARCHARACTER', >> 'VARYING', >> 'WHEN', >> 'WHERE', >> 'WHILE', >> 'WITH', >> 'WRITE', >> 'XOR', >> 'YEAR_MONTH', >> 'ZEROFILL', >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To post to this group, send email to web...@googlegroups.com. >> To unsubscribe from this group, send email to >> web2py+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/web2py?hl=en. >> >> > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
