字段ID：primary和auto_increment.need要填充？ [关闭]

Question

If I have a mysql table made in this way:

CREATE TABLE users(
    id int( 11 ) NOT NULL AUTO_INCREMENT ,
    name varchar( 80 ) NOT NULL ,
    surname varchar( 80 ) NOT NULL ,
    address varchar( 80 ) NOT NULL ,
    birth_place varchar( 50 ) NOT NULL ,
    province varchar( 5 ) NOT NULL ,
    birth_date date NOT NULL ,
    sex enum( 'male', 'female' ) NOT NULL DEFAULT 'male',
    treatment enum( 'politrauma', 'cardiologico', 'neurologico' ) NOT NULL DEFAULT 'politrauma',
  PRIMARY KEY ( id )
) ENGINE = MYISAM DEFAULT CHARSET = utf8

and I execute a query to insert data like so:

"INSERT INTO users (name, 
                    surname, 
                    address, 
                    birth_place,
                    province,
                    dt,
                    sex,
                    treatment) value (:name
                                      :surname,
                                      :address,
                                                        :birth_place,
                                                        :province,
                                                        :dt,
                                                        :sex,
                                                        :treatment)"

without fill id in mysql table.this can be cause of error?mysql will fill automatically id with a int value?

Answer 1

as a guess you want:

ALTER TABLE `XXX` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT ;