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
xpected.
> Tables are very simple: MyChannels contains two int columns,
> MyPackages - just one int column.
>
>
> >How-To-Repeat:
>
> >Fix:
>
>
> >Submitter-Id:
> >Originator:
> >Organization:
>
> >M
How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: none
>Synopsis: Multi-table delete is broken in MySQL 4.0.2
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Rel