CREATE TRIGGER s_name after INSERT on playeritems FOR each row
BEGIN
UPDATE playeritems p SET p.flags = '0' WHERE p.pid in (SELECT p1.pid from playeritems p1 where p1.flags = '1');
end
DELAYED;
备注：p.id 是playeritems表的ID；
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024