MySQL fails on "create table log(" - needs "log (" instead

[Former user]

In source:/sqlalchemy/trunk/lib/sqlalchemy/ansisql.py ANSISchemaGenerator.visit_table "create table" is appended with the table name and a parenthesis "(". MySQL seems to raise a syntax error on this if the table name is "log".

Adding a space character between the table name and the parenthesis fixes the problem.

[Mike Bayer]

per http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html , quotes are a more general solution.

please let me know if quoting the identifier works as well.

[Former user]

Yes, backtick-quoting solves the problem too.

[Mike Bayer]

quoting is a bigger headache...i just added the single space in changeset:1643....mysql is just so dumb....