OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: CLI can't read data from table

From: Mike Diehl (mdiehldiehlnet.com)
Date: Wed Apr 14 2010 - 19:05:45 CDT

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.

Thanks.

--

Take care and have fun,
Mike Diehl.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql