01-23-2014, 09:24 PM
mysql --user=usernamehere --password=passwordhere -e "UPDATE newproject_auth.bg_user SET cash = cash + 5 WHERE user_code in (SELECT a_portal_index FROM newproject_auth.t_users WHERE a_zone_num >= 0"
try this one
I got this error now
ERROR 1064 (42000) at line 1: 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 1

