On Sep 28, 2011, at 12:54 PM, Se7en SenSeS wrote:

> I was to create a table named ORDER to keep track of customers' orders but 
> there was an exception thrown enforcing me to use another name. I can have 
> the job done perfectly by any other DBMS like MySQL, SQL Server. Please help 
> me figure out whether it is a bug or not?

order is a reserved word [1].

quote the name if you want to use it, e.g. "order".

[1] http://www.sqlite.org/lang_keywords.html

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to