MYSQL导出一个SQL后: DELIMITER $$ DROP TRIGGER IF EXISTS updateegopriceondelete$$ CREATE TRIGGER updateegopriceondelete AFTER DELETE ON customerinfo FOR EACH ROW BEGIN DELETE FROM egoprice WHERE customerId=
复制代码 代码如下: USE master DECLARE @spid int DECLARE CUR CURSOR FOR SELECT spid FROM sysprocesses WHERE dbid = 5 FETCH NEXT FROM CUR INTO @spid WHILE @@FETCH_STATUS = 0 BEGIN --EXEC ('KILL ' + @spid ) FETC
