On 11 Nov 2013, at 11:08am, dd <durga.d...@gmail.com> wrote: > How do I insert trackname as "That's Amore" and artistname as "Dean > Martin" with single query in artist and track tables?
Sorry, I don't know a way to do that. I hope someone else has a way but it's normal to have your software figure out that you need to create artist/publisher/whatever rows first. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users