Need help on Multi-table update queries

Hi, I m using MySQL 4.0.2 which now supports multi-table update query I am getting error while throwing multi-table UPDATE query, I don't know what the problem is To generate an error run below query, it will create a 2 InnoDB table and inserts a dummy record in it CREATE TABLE `systemdefault`

Need help on Multi-table update queries

Hi, I m using MySQL 4.0.2 which now supports multi-table update query I am getting error while throwing multi-table UPDATE query, I don't know what the problem is To generate an error run below query, it will create a 2 InnoDB table and inserts a dummy record in it CREATE TABLE `systemdefault`