把上面的语句写完整试试看,即:
update prod_type as p,order_temp as pd set p.prod_num=(p.prod_num-pd.shuliang) where p.type_id=pd.type_id and pd.rand_id='27';
update prod_type as p,order_temp as pd set p.prod_num=(p.prod_num-pd.shuliang) where p.type_id=pd.type_id and pd.rand_id='27';
SQL 語法: UPDATE prod_type AS p,
order_temp AS pd SET p.prod_num = ( p.prod_num - pd.shuliang ) WHERE p.type_id = pd.type_id AND pd.rand_id = '27'
MySQL 傳回: #1064 - You have an error in your SQL syntax near 'as p,order_temp as pd set p.prod_num=(p.prod_num-pd.shuliang) where p.type_id=pd' at line 1