Kevin Ford wrote:
> I am getting this ERROR
> SQL-query :
> UPDATE products_test, dev_products
> SET products_test.products_price =
> WHERE (products_test.products_id =
> MySQL said:
> #1064 - You have an error in your SQL syntax near
> 'dev_products SET products_test.products_price =
> dev_products.products_price WHE' at line 1
> MYSQL VERSIONS IS MySQL 3.23.58
Multi-table UPDATE and DELETE are available in MySQL 4.0 and up. Some features are only available from the current production version, MySQL 4.1.
See also http://dev.mysql.com/doc/mysql/en/update.html
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.
Follow us at http://openquery.com/blog/