MySQL INSERT INTO: Multiple lines with one query [duplicate]

Question

I have a table DateID just with two fields:

id (integer), date(datetime)

id          date
1           2013-06-27 12:00:00
2           2013-06-27 12:00:00

I need to populate the table with 2 new lines with just one query. Is it possible?

Data:

id =1 date= 2013-06-27 12:00:00;
id =1 date= 2014-06-27 12:00:00;

$insert = mysql_query("INSERT INTO DateID(id,) 
values ('1','20141127120000,20161027120000')");//is this possible?

oh and use mysqli just to be future proof php.net/manual/en/book.mysqli.php :) — Prashank
– Prashank, Commented Nov 12, 2013 at 18:57
Be aware that the mysql_*() functions are deprecated and support for them will be removed. For new code use mysqli or PDO. The suggested queries given will still be valid. — user1864610
– user1864610, Commented Nov 12, 2013 at 18:57
or use a prepared statement and just repeat the same query with new parameters. — Marcel Korpel
– Marcel Korpel, Commented Nov 12, 2013 at 18:57

juergen d · Accepted Answer · 2013-11-12 18:53:20Z

5

INSERT INTO DateID(id,date) 
values (1,'20141127120000'),
       (2,'20161027120000')

answered Nov 12, 2013 at 18:53

juergen d

205k40 gold badges305 silver badges377 bronze badges

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

Comments

Prashank · Accepted Answer · 2013-11-12 18:54:21Z

0

You could try this probably?

$insert = mysql_query("INSERT INTO DateID(id, date) VALUES ('1','20141127120000'), ('2', '20161027120000')");

answered Nov 12, 2013 at 18:54

Prashank

7966 silver badges12 bronze badges

Collectives™ on Stack Overflow

MySQL INSERT INTO: Multiple lines with one query [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related