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 limit 1;
A name that's not a valid identifier (a sequence of letters and digits
beginning with a letter) should be enclosed in double quotes.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
