On 30 Dec 2014, at 6:19pm, Jonathan Leslie <j...@jonathanleslie.com> wrote:
> C:\jon>cat t2.lis | gawk "/.*/ { print \"delete from \" $3 \" where \" $4 }"
> |cut -d"," -f1delete from "parent01" where VALUES(1417556005delete from
> "child01" where VALUES(1417626376delete from "child01" where
> VALUES(1417626391delete from "child01" where VALUES(1417703626delete from
> "child01" where VALUES(1417703753delete from "child01" where VALUES(1419259626
Wait ... you're doing all this just so you can delete the child rows ? Then
why don't you just set delete to CASCADE and let SQLite do it all for you ?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
