Re: [sqlite] problem with creating a table

[Bijan Farhoudi]

A. Pagaltzis wrote:

* Bijan Farhoudi <[EMAIL PROTECTED]> [2006-06-25 16:35]:

Thanks for your answer but still I am getting an error message:
sqlite> create table foo(i integer, [order] integer);
sqlite> .sch
CREATE TABLE foo(i integer, [order] integer);
sqlite> insert into foo values(1,2);
sqlite> select order from foo
  ...> ;
SQL error: near "order": syntax error

Any other idea?

    .headers on
    SELECT [order] FROM foo

But how would you know the name of the col is "order"  not "[order]"?