Bijan Farhoudi <[EMAIL PROTECTED]> writes:
> 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)')
You're working on dangerous ground when you use reserved words as your column
names. 'order' is a reserved word, as it is used for the ORDER BY clause.
You can do it, though, like this:
create table foo(i integer, [order] integer)
Placing column names in square brackets lets you use reserved words as column
names.
Derrell
