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
[email protected]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
