Homec4science

Do not use table aliases in "DELETE x FROM ... LEFT JOIN" SQL statements…

Authored by Tibor Simko <tibor.simko@cern.ch> on Dec 7 2006, 14:23.

Description

Do not use table aliases in "DELETE x FROM ... LEFT JOIN" SQL statements, because MySQL 4.0 and 5.0 behave differently in this regard. (One version requires aliases to be in x too, the other version forbids it.)

Event Timeline

Tibor Simko <tibor.simko@cern.ch> committed R3600:b87c8d0d9798: Do not use table aliases in "DELETE x FROM ... LEFT JOIN" SQL statements… (authored by Tibor Simko <tibor.simko@cern.ch>).Dec 7 2006, 14:23