mysql支持多表联合更新嘛?我想两个表同时更新,怎么办呢?
sql = "UPDATE SMS_DATABASE1.program a,SMS_DATABASE1.customer b SET a.pname='"+programname1+"',"
+ "b.cid = '"+cid+"',"
+ "b.cname = '"+customername1+"'"
+ "b.content = '"+content1+"',"
+ "b.password = '"+password+"'"
+ "b.p_id = '"+pid+"'"
+" where b.p_id = a.pid and b.id ='" + id + "'";
我的sql,应该怎么处理一下,大侠帮忙~~~