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 — Stephan Weinhold
– Stephan Weinhold, Commented Apr 23, 2015 at 6:38

Stephan Weinhold · Accepted Answer · 2015-04-23 06:39:48Z

1

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

answered Apr 23, 2015 at 6:39

Stephan Weinhold

1,6411 gold badge28 silver badges37 bronze badges

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

Comments

Rex Rex · Accepted Answer · 2015-04-23 06:40:07Z

0

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

answered Apr 23, 2015 at 6:40

Rex Rex

1,0301 gold badge8 silver badges30 bronze badges

Collectives™ on Stack Overflow

Multiple INSERT query's fetching last_insert_id of each each

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related