UPDATE ecs_goods
INNER JOIN test bookcontent
on ecs_goods.goods_sn=test.grade
set ecs_goods.goods_desc=test.bookcontent
显示错误 [Err] 1054 - Unknown column 'test.grade' in 'on clause' 各位大神 是哪里出错了
INNER JOIN test bookcontent
on ecs_goods.goods_sn=test.grade
set ecs_goods.goods_desc=test.bookcontent
显示错误 [Err] 1054 - Unknown column 'test.grade' in 'on clause' 各位大神 是哪里出错了
INNER JOIN test
on ecs_goods.goods_sn=test.grade
set ecs_goods.goods_desc=test.bookcontent