#设置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