Simon,
On Tue, Dec 30, 2014 at 1:41 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> 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 ?
It's not even SQLite - its basic SQL. ;-)
Thank you.
>
> Simon.
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
