MySQL insert row with only default values

Question

I would like to insert a row with only the default values (which I will then update later since I need the ID autoincremented field)

This works in SQL Server (How to insert a record with only default values?)

insert into myTable DEFAULT  VALUES;

But how can I accomplish this in MySQL:

I also tried:

insert into myTable;

which fails. I know I can work around with the standard insert syntax, but there are a lot of columns in my table so a simple syntax if it exists would be helpful.

I update my post, you can even use INSERT INTO myTable () VALUES(); look dev.mysql.com/doc/refman/5.6/en/insert.html for more info ;) — Blag
– Blag, Commented Dec 6, 2015 at 21:24

Blag · Accepted Answer · 2015-12-06 21:22:32Z

10

This will do it :

INSERT INTO `myTable` (`id`)
VALUES 
    (null),
    (null);
-- or 
INSERT INTO `myTable` () 
VALUES();

SQL Fiddle

MySQL 5.6 Schema Setup:

CREATE TABLE Table1
    (`id` int AUTO_INCREMENT PRIMARY KEY, `title` varchar(5) DEFAULT '***')
;

INSERT INTO Table1
    (`id`, `title`)
VALUES
    (1, 'hi'),
    (2, 'hello')
;

INSERT INTO Table1
    (`id`)
VALUES
    (null),
    (null)
;
INSERT INTO Table1 () VALUES();

Query 1:

SELECT * from Table1

Results:

| id | title |
|----|-------|
|  1 |    hi |
|  2 | hello |
|  3 |   *** |
|  4 |   *** |
|  5 |   *** |

edited Dec 6, 2015 at 21:22

answered Dec 6, 2015 at 21:17

Blag

5,8942 gold badges26 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL insert row with only default values

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related