MariaDB 10.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (
	id INT PRIMARY KEY AUTO_INCREMENT,
	code INT CHECK(code>0),
	data VARCHAR(255)
) ENGINE=INNODB;
INSERT INTO test(code,data) VALUES(23,'apple');
START TRANSACTION;	

INSERT INTO test(code,data) VALUES(45,'banana');
INSERT INTO test(code,data) VALUES(-3,'banjo');

COMMIT;

CONSTRAINT `test.code` failed for `fiddle`.`test`


SELECT * FROM test;


id
code
data


1
23
apple

2
45
banana