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

Reply via email to