By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE animals (
id MEDIUMINT NOT NULL,
name CHAR(30) NOT NULL,
sequence BIGINT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
);
Incorrect table definition; there can be only one auto column and it must be defined as a key
CREATE TABLE animals (
id MEDIUMINT NOT NULL,
name CHAR(30) NOT NULL,
sequence BIGINT NOT NULL AUTO_INCREMENT,
other_sequence BIGINT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id), UNIQUE(sequence), UNIQUE(other_sequence)
);
Incorrect table definition; there can be only one auto column and it must be defined as a key