SQL column count does not match value count error

Question

I have this table:

CREATE TABLE `message` (
    `m_id` INT(11) NOT NULL AUTO_INCREMENT,
    `p_id` VARCHAR(30) NOT NULL,
    PRIMARY KEY (`m_id`)
)
ENGINE=InnoDB
ROW_FORMAT=DEFAULT

and this insert

INSERT INTO `message` VALUES ('7');

and I am receiving a "column count does not match a row value count" error. It should work fine since the primary key is auto_increment.

Answer 1

You can do this

INSERT INTO `message` VALUES (NULL, '7');

This will match the number of columns and ignore the null insert into the auto increment id and insert the auto increment value;