Insert values in a row with auto-increment

According to the MySQL documentation, it is recommended to insert NULL:

link

  

An integer or floating-point column can have the additional attribute AUTO_INCREMENT. When you insert a value of NULL (recommended) or 0 into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. Typically this is value + 1, where value is the largest value for the column currently in the table. AUTO_INCREMENT sequences begin with 1.

The value "0" works unless you have the NO_AUTO_VALUE_ON_ZERO activated.

It also specifies the documentation that it is not necessary to specify a value for that field when inserting data in the other fields of the row, and that you can insert NULL if the field is NOT NULL or assign a specific value (10, 25, 1000, ...) and the sequence will have the largest value in the column as a new value.

link

  

No value was specified for the AUTO_INCREMENT column, so MySQL assigned sequence numbers automatically. You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. If the column is declared NOT NULL, it is also possible to assign NULL to the column to generate sequence numbers. When you insert any other value into an AUTO_INCREMENT column, the column is set to that value and the sequence is reset so that the next automatically generated value follows sequentially from the largest column value.

Option 1, pass it a NULL:

insert into empleados values(NULL, 'perico', 'palotes', 'de dios', 4587, '[email protected]', 'MADR-ES', 3, 'Representante ventas')

Option 2, as you comment, you can specify the fields to insert, you can skip the id field since it is as auto-incremental you will not need to worry about it:

insert into empleados (campo1,campo2,campo8) values('perico', 'palotes', 'de dios', 4587, '[email protected]', 'MADR-ES', 3, 'Representante ventas')

When the field is defined as auto-increment in the DB you do not have to indicate it, you just have to pass the fields that are not auto-increment and the safest way to do it is ...

string query = "INSERT INTO Empleados(campo1, campo2, campo3) Values(@c1, @c2, @c3)";
using(SqlCommand cmd = new Sqlcommand(query, conexion)){
    cmd.Parameters.AddWithValue("@c1", 'perico');
    cmd.Parameters.AddWithValue("@c2", 'palotes');
    cmd.Parameters.AddWithValue("@c3", 'de dios');
    cmd.ExcecuteNonQuery();
}