Re: [sqlite] Column names in SQL

On Mon, Jun 28, 2010 at 10:07 AM, Serdar Genc wrote: > I have already tried it but not working.. :( > Works for me. punk...@lucknow ~$sqlite3 -- Loading resources from /Users/punkish/.sqliterc SQLite version 3.6.23 Enter ".help" for instructions Enter SQL statements

Re: [sqlite] Column names in SQL

I have already tried it but not working.. :( On Mon, Jun 28, 2010 at 6:01 PM, P Kishor wrote: > On Mon, Jun 28, 2010 at 9:58 AM, Serdar Genc > wrote: > > Hi everyone, > > > > I have a problem related to column names . I have a column name as a[b] >

Re: [sqlite] Column names in SQL

On Mon, Jun 28, 2010 at 9:58 AM, Serdar Genc wrote: > Hi everyone, > > I have a problem related to column names . I have a column name as a[b] in > my table but > this creates a problem when using SELECT statement as > SELECT a[b] from Table. I know [] is a special

[sqlite] Column names in SQL

Hi everyone, I have a problem related to column names . I have a column name as a[b] in my table but this creates a problem when using SELECT statement as SELECT a[b] from Table. I know [] is a special character but How would I tell SQlite that field name is a[b] and I am not using [] with a