Insert manually into a table by SQL statement, but key is autoincremented

Question

Let's say I have a table of users and the id column is the primary key and auto incremented.

I want to just try and add user manually by this statement:

INSERT INTO table_name (id, username, password)  
VALUES (?, Mike, Mike);

but I don't want to specify the ? value, just want to add to the next row.

Thanks everyone, I forgot to set the id column to auto increment. it works now.

Answer 1

So just don't use it...do it like this..

And be sure you use single quotes for inserting strings

INSERT INTO table_name (username, password)
VALUES ('Mike', 'Mike');

As you said your field is auto incremented, SQL will automatically increment the value of the id field by 1

Answer 2

If you want to manually insert a value to an auto incremented column you can use the IDENTITY_INSERT of sql. for example

SET IDENTITY_INSERT MyTable ON
insert into MyTable(id, name) values (1,'asdf');
insert into MyTable(id, name) values (3,'htgfds');
insert into MyTable(id, name) values (123,'dsfg');
SET IDENTITY_INSERT MyTable OFF

you can read more here IDENTITY_INSERT