Hi I am trying to run this query on my MySql db
update work_order set current_date = order_date;
but I keep getting this following 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 'current_date = order_date' at line 1
Both columns have type 'date'. Can someone let me know why this is happening and how I can do this update. Thanks.