In the last episode (Apr 14), Mike Diehl said: > On Wednesday 14 April 2010 5:49:43 pm Jesper Wisborg Krogh wrote: > > Lines is a reserved keyword (e.g. like in "LINES TERMINATED BY"), so it > > must be quoted: > > > > test> use test; > > Database changed > > test> CREATE TABLE `lines` (id int unsigned NOT NULL PRIMARY KEY) > > ENGINE=InnoDB; Query OK, 0 rows affected (0.20 sec) > > Yup, that was it. I'm migrating from Postgres, so it never occured to me > that "lines" might be reserved.
On the plus side, you can now use the word "vacuum" :) -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org