List:General Discussion« Previous MessageNext Message »
From:Mike Diehl Date:April 15 2010 5:20pm
Subject:Re: CLI can't read data from table
View as plain text  
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 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" :)

I needed a good chuckle.  Thank you!

-- 

Take care and have fun,
Mike Diehl.
Thread
CLI can't read data from tableMike Diehl15 Apr
  • Re: CLI can't read data from tableJesper Wisborg Krogh15 Apr
    • Re: CLI can't read data from tableMike Diehl15 Apr
      • Re: CLI can't read data from tableDan Nelson15 Apr
        • Re: CLI can't read data from tableMike Diehl15 Apr