[plug] SQL help

[Craig Ringer]

Benjamin Woods wrote:
> I have just spoken to some people on irc and they say that mysql 3.23 cannot 
> do multitable updates.

Given that, and that it can't handle subqueries, you might have to do it 
using a simple script.

> they recommended upgrading the mysql server to 4.0.X 
> after testing and backing up server.

That strikes me as very much the way to go if you can, though it does 
depend on your client application(s) . I found the MySQL 3.x -> 4.x 
upgrade to be astonishingly simple, painless, and transparent - it 
really "just worked" like very little else does. It's well worth a go.

Of course, you really should "upgrade" to PostgreSQL :-P

--
Craig Ringer