Re: [sqlite] problem with creating a table

[John Stanton]

Bijan Farhoudi wrote:

Hi,

I am trying to create table and I would like to name one of the columns order, but pysqlite does not like it. I do not want to have order__ or any thing like that.

for example the following command does not work:
cur.execute('create table foo(i integer, order integer)')

How can I fix this problem?

Regards,
   Bijan

By only using ORDER as an SQL keyword.