为什么我这样写编译不过去:
DROP TRIGGER IF EXISTS trig_T_ChatUserInfo_ad
DROP TRIGGER trig_T_ChatUserInfo_ad IF EXISTS trig_T_ChatUserInfo_ad
DROP TRIGGER IF EXISTS trig_T_ChatUserInfo_ad
DROP TRIGGER trig_T_ChatUserInfo_ad IF EXISTS trig_T_ChatUserInfo_ad
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME = "trig_T_ChatUserInfo_ad" AND TYPE = "TR")
DROP TRIGGER trig_T_ChatUserInfo_ad
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME = "trig_T_ChatUserInfo_ad" AND TYPE = "TR") DROP TRIGGER trig_T_ChatUserInfo_adYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME = "trig_T_ChatUserInfo_ad" AND ' at line 1
DROP TRIGGER IF EXISTS `trig_T_ChatUserInfo_ad`
DROP TRIGGER IF EXISTS `trig_T_ChatUserInfo_ad`试过了,仍旧不行。你们有没有在自己的mysql服务器上试过呢。还是我的服务器的问题?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS `trig_T_ChatUserInfo_ad`' at line 1