Kevin Ford wrote:
> I am getting this ERROR
>
> Error
> SQL-query :
> UPDATE products_test, dev_products
> SET products_test.products_price =
> dev_products.products_price
> WHERE (products_test.products_id =
> dev_products.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
Regards, Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.
Follow us at
http://openquery.com/blog/ &
http://twitter.com/openquery