DELIMITER$$ CREATE TRIGGER `trTemplate` BEFORE DELETE ON `tb` FOR EACH ROW BEGIN IF old.id=1 THEN ROLLBACK; END IF; END$$
DELIMITER;
DELETE from tb WHERE id=1
DROP TRIGGER trTemplate 总是报语法错误
把出错信息一起贴出来大家看一下。 SQL code: 错误码: 1422 Explicit or implicit commit is not allowed in stored function or trigger.
Execution Time : 00:00:00:000 Transfer Time : 00:00:00:000 Total Time : 00:00:00:000
错误码: 1064 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 'DELIMITER' at line 1
mysql 可以给触发器显式或隐式方式开始或结束事务的语句吗？ 帮我写个这种需求的触发器呵，谢了 触发器中不能有 commit; rollback 这种事务语句。类似功能的实现可以参考下贴。
先上错误 无法联接数据库 java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
