At 15:10 27/12/2011, Mohit Sindhwani wrote:
On 27/12/2011 9:25 PM, Eduardo Morras wrote:
At 11:27 27/12/2011, you wrote:
Thank you. I agree. It's correct.
I already have data base with /country/state/city/village format. Is it
possible to do that while virtual table creation time?
if yes, how?
Change '/' to ','. This way you get a csv file which you can import
directly. Perhaps you need to add a line with the table column description.
or at the SQLite3 shell do
sqlite>separator /
before doing a .import
no?
Yes, didn't remember.
Cheers,
Mohit.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
