用了条这样的语句
$sql="update mission_book set a.mission_status=2 from mission_book a inner join mission_item b on 13=13 where a.player_id=$user_id and a.mission_id=$mission_id";这样写报错 请问update 中的inner join改怎么写啊
$sql="update mission_book set a.mission_status=2 from mission_book a inner join mission_item b on 13=13 where a.player_id=$user_id and a.mission_id=$mission_id";这样写报错 请问update 中的inner join改怎么写啊
update mission_book a inner join mission_item b on 13=13
set a.mission_status=2
where a.player_id=$user_id and a.mission_id=$mission_id不如直接
update mission_book a
set a.mission_status=2
where a.player_id=$user_id and a.mission_id=$mission_id你可以参考一下MySQL手册中的例子。
http://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html#update
13.2.10. UPDATE语法
Multiple-table语法:
update mission_book a set a.mission_status=2 where a.player_id=$user_id and a.mission_id=$mission_id