Hi!
On Friday 01 November 2002 15:03, Jon Frisby wrote:
> Why not just do:
> DELETE FROM MyChannels;
> DELETE FROM MyPackages;
>
> If you're concerned about atomicity, simply acquire a lock on both
> tables at once first.
Exactly, it was my concern. I'm not using MySQL tables with transaction
sup
If you do:
SELECT * FROM MyChannels, MyPackages;
Then you should also get nothing because what you're asking the database
to do is to perform a cartesian cross of the rows in both tables. Since
there's no row in one of the tables, the cross will contain no rows.
Ideally one could do:
DELETE FR