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.
in case, if I have 250 levels like this ex: file system. how to do this.
any idea?
You can use a shell script to do so. I leave it as exercise to you ;)
Thanks in advance.
HTH
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users