Re: [sqlite] Table name in attach'ed databases

2013-07-20 Thread Igor Tandetnik
On 7/20/2013 7:33 PM, Simon Slavin wrote: The problem here is that various tutorials have shown incorrect examples for the thing after the 'AS'. Some show it without quotes, and some show it with single quotes. If I understand correctly the intention of the developers is that the name should

Re: [sqlite] Table name in attach'ed databases

2013-07-20 Thread Simon Slavin
On 21 Jul 2013, at 12:20am, Igor Tandetnik wrote: > On 7/20/2013 5:33 PM, V.Krishn wrote: >> following works: >> attach database 'file:test.db' as 'test'; #OK >> select * from test.employees limit 1; #OK >> >> but, >> attach database 'file:test.db' as '123test'; #OK >> select * from 123test.emp

Re: [sqlite] Table name in attach'ed databases

2013-07-20 Thread V.Krishn
On Sunday, July 21, 2013 04:50:16 AM Igor Tandetnik wrote: > On 7/20/2013 5:33 PM, V.Krishn wrote: > > following works: > > attach database 'file:test.db' as 'test'; #OK > > select * from test.employees limit 1; #OK > > > > but, > > attach database 'file:test.db' as '123test'; #OK > > select * fro

Re: [sqlite] Table name in attach'ed databases

2013-07-20 Thread Igor Tandetnik
On 7/20/2013 5:33 PM, V.Krishn wrote: following works: attach database 'file:test.db' as 'test'; #OK select * from test.employees limit 1; #OK but, attach database 'file:test.db' as '123test'; #OK select * from 123test.employees limit 1; #Gives error Try select * from "123test".employees limi

Re: [sqlite] Table name in attach'ed databases

2013-07-20 Thread Kees Nuyt
On Sun, 21 Jul 2013 03:03:10 +0530, "V.Krishn" wrote: >following works: >attach database 'file:test.db' as 'test'; #OK >select * from test.employees limit 1; #OK > >but, >attach database 'file:test.db' as '123test'; #OK >select * from 123test.employees limit 1; #Gives error > >I hope this is not