Multiple INSERT query's fetching last_insert_id of each each

Question

mysql_query( "INSERT INTO users(email, password) VALUES ('$email','$password')" );
$user_id = mysql_insert_id( );

mysql_query( "INSERT INTO business_details ( business_id, name, address, city, state, country, pincode) VALUES ('$category','$business_name', '$business_address', '$city', '$state', '$country', '$pincode')" );
$idB = mysql_insert_id( );

mysql_query( "INSERT INTO user_profiles (name, phone, user_id, business_details_id) VALUES ('$person_name', '$phone_number', '$user_id', '$idB')" );

What will be the best way to insert all queries in one? Is it possible?

possible duplicate of [sql - insert into multiple tables in one query](http://stackoverflow.com/questions/3860280/sql-insert-into-multiple-tables-in-one-query) — Stephan Weinhold, Apr 23 '15 at 06:38

score 1 · Answer 1 · answered Apr 23 '15 at 06:39

1

No, it isn't supported in MySQL - only Oracle can do it.

answered Apr 23 '15 at 06:39

Stephan Weinhold

1,623
1
28
37

score 0 · Answer 2 · answered Apr 23 '15 at 06:40

0

MySQL doesn't support multi-table insertion in a single INSERT statement

answered Apr 23 '15 at 06:40

Rex Rex

1,030
1
8
29

Multiple INSERT query's fetching last_insert_id of each each

2 Answers2