mysql 结合点

#设置savepoint  结点名
show engines;

SET autocommit = 0;

start transaction;

INSERT dept(dname) VALUES('caster');

savepoint x;

INSERT dept(dname) VALUES('ruler');

SELECT * FROM dept;

#回滚结合点
ROLLBACK TO x;

commit;


CREATE TABLE `dept`  (
  `dept_no` bigint(20) NOT NULL AUTO_INCREMENT,
  `dname` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '主从数据',
  `db_source` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time` datetime(0) DEFAULT CURRENT_TIMESTAMP,
  `deleted` tinyint(2) DEFAULT 0,
  `sex` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`dept_no`) USING BTREE,
  FULLTEXT INDEX `1231`(`dname`, `sex`)
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = '部门表' ROW_FORMAT = Compact;

该操作会回到插入到caster的sql