How to insert an empty line to SQL table?

Question

Possible Duplicate:
Inserting rows into a table with one IDENTITY column only

I have a SQL table with just one column. Column is an autoincrement field like:

Id INT IDENTITY

I need to insert a rows to this table (this is a bulk/dummy table temporarily):

INSERT INTO my_table VALUES ()

But I'm got a syntax error.

How can I do this?

score 122 · Accepted Answer · answered Nov 28 '12 at 12:39

122

INSERT INTO my_table DEFAULT VALUES

answered Nov 28 '12 at 12:39

gbn

http://sqlfiddle.com/#!3/75183/3/1 – John Sobolewski Nov 28 '12 at 12:42
What if I want to do it for thousands of rows? Is there any smarter way than just doing this thousands of times? – Ben Farmer Jan 11 '20 at 21:34
You can add multiple rows like this: `INSERT INTO my_table VALUES (DEFAULT), (DEFAULT)` – Pâris Douady Aug 17 '21 at 10:41

score 3 · Answer 2 · answered Nov 28 '12 at 12:39

3

Try to insert explicit null values:

INSERT INTO my_table VALUES (NULL, NULL);

answered Nov 28 '12 at 12:39

Philipp

2 Answers2