INSERT Data From One Table Into Multiple Tables in MySQL

Question

I am looking for an example query that will allow me to insert data from a table into multiple(2) tables. I read this post but it is for Microsoft SQL Server only and am not sure if this is how you do it in MySQL.

Thanks in advance.

Just doing it twice would probably be the easiest way

Pekka
– Pekka

2012-10-10 19:36:42 +00:00
Commented Oct 10, 2012 at 19:36 — Pekka
– Pekka, Commented Oct 10, 2012 at 19:36

Vyktor · Accepted Answer · 2012-10-10 19:38:51Z

1

AFAIK mysql doesn't provide a way for inserting data into multiple tables in one command.

You have to use multiple commands, but you may lock table before using them to assure data integrity.

answered Oct 10, 2012 at 19:38

Vyktor

21.1k6 gold badges69 silver badges98 bronze badges

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

2 Comments

user330315 Over a year ago

Why would you need to lock the table?

Vyktor Over a year ago

Lets say he would be inserting 100k records and he will want to prevent user from adding records to t2 so the data will be consistent.

Lian · Accepted Answer · 2012-10-12 02:02:42Z

1

you will need to use multiple query/commands in order to insert into multiple tables.

$sql1 = mysql_query("SELECT * FROM tbl1");
$result = mysql_fetch_assoc($sql1);

$item1 = $result['item1'];
$item2 = $result['item2'];

$save_to_tbl2 = ("INSERT INTO tbl2(item1,item2)VALUES('".$item1."','"item2."')";
$save = mysql_query(save_to_tbl2);

$save_to_tbl3 = ("INSERT INTO tbl3(item1,item2)VALUES('".$item1."','"item2."')";
$save = mysql_query(save_to_tbl3);

edited Oct 12, 2012 at 2:02

answered Oct 11, 2012 at 9:56

Lian

1,6293 gold badges18 silver badges31 bronze badges

Collectives™ on Stack Overflow

INSERT Data From One Table Into Multiple Tables in MySQL

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related