MySQL中,sql语句中变量的声明和使用
SET @openId='3on1234234adfweradf2345';
/*删除系统用*/
DELETE FROM `SYS_USER` WHERE id IN (SELECT a.`USER_ID` FROM `WEIXIN_USER` a WHERE a.`OPEN_ID`=@openId);
/*删除微信用户*/
DELETE FROM `WEIXIN_USER` WHERE `OPEN_ID`=@openId;
MySQL中,sql语句中变量的声明和使用
SET @openId='3on1234234adfweradf2345';
/*删除系统用*/
DELETE FROM `SYS_USER` WHERE id IN (SELECT a.`USER_ID` FROM `WEIXIN_USER` a WHERE a.`OPEN_ID`=@openId);
/*删除微信用户*/
DELETE FROM `WEIXIN_USER` WHERE `OPEN_ID`=@openId;