SQL Error

[sbmk1957]

Hi people

Not exactly oscommerce related .. but i run an sql update in the db manually at the moment for stock quanities , incoming stock etc .. the following SQL used to work .. now that i moved to another server it doesnt so version change in Mysql seems the issue 

Current Mysql version is now 5.5.42-37.1 - i dont know the previous and can no longer access it ;/

any ideas gratefully accepted !

 

SQL statement

 

update products_to_wholesale

set expected_date = (select products_update.expected_date from products_update where products_update.products_id = products_to_wholesale.products_id)

where exists (select products_update.expected_date from products_update where products_update.products_id = products_to_wholesale.products_id)

 

and the error

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2

 

Cheers

 

Steve

[sbmk1957]

all sorted .. the new host defaults to ";" delimiter and i didnt notice that ... for hours :(