I'm using 3.23.37, and I am taking a random subset of records from a table,
and putting them into another table:
insert into targettable select * from sourcetable;
I then want to delete these records from the source table. I have tried
various permutations of:
delete from sourcetable select *
I then want to delete these records from the source table. I have tried
various permutations of:
delete from sourcetable select * from sourcetable,targettable where
sourcetable.id=targettable.id;
but with no luck.
The archive only seems to have questions relating to multi-table