On Wednesday 14 April 2010 7:39:03 pm Dan Nelson wrote:
> 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 te
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 unsi
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
On Thu, 15 Apr 2010 09:31:04 Mike Diehl wrote:
> I just created a new table called "lines." I can use Open Office to read
> the records in it just fine.
>
> However, when I type this command at the cli, I get an error:
>
>
> select * from lines;
> ERROR 1064 (42000): You have an error in your SQL
