When a table has an AUTO_INCREMENT PRIMARY KEY, normally one does not insert into that column.  Instead, specify all the other columns, then ask what the new id was.
CREATE TABLE t (
    id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL,
    this ...,
    that ...,
    PRIMARY KEY(id) );
INSERT I...