> -----Original Message----- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Sunday, June 25, 2006 10:19 AM > To: SQLite > Subject: [sqlite] Re: problem with creating a table > > > Bijan Farhoudi > <farhoudi-RazJlWb3c/[EMAIL PROTECTED]> wrote: > > A. Pagaltzis wrote: > >> SELECT [order] FROM foo > >> > > But how would you know the name of the col is "order" not > "[order]"? > > Square brackets are not part of the name. They are delimiters that > indicate that whatever's inside is to be treated as an > identifier (just > as in string literal 'x', quotes are not part of the string but are > delimiters indicating that it is indeed a string literal). > This syntax > allows identifiers that would otherwise be reserved words, as well as > identifiers that otherwise would not be valid (e.g. having spaces or > punctuation in them, e.g. [this is a valid column name] ). > > Igor Tandetnik >
If brackets are a visual distraction, more common " Quote Marks may be used as well.