How to insert different values into two tables with single submit and inner join in MySQL

Question

is it possible to insert Values into two tables using inner join..? tables are user,details

user table contains user_id,name,passwrd

details table contain id,address,email

what i Did:

    if(isset($_POST['submit'])=='SUBMIT')
  {

       $user_name        =   $_POST['user_name'];
       $user_password    =   $_POST['user_password'];

       $details_email   =   $_POST['details_email']; 
       $details_phn      =   $_POST['details_phn'];
       $details_age     =   $_POST['details_age'];

 $SQL_QUERY="INSERT INTO tbl_user(user_name,user_password)VALUES('$user_name','$user_password')";
 $result=mysql_query($SQL_QUERY);

   $SQL_QUERY1="INSERT INTO tbl_details(details_email,details_phn,details_age)VALUES('$details_email','$details_phn','$details_age')";
 $result1=mysql_query($SQL_QUERY1);

   }

how can i rewrite with innerjoin...pls someone help me..

possible duplicate of [sql - insert into multiple tables in one query](http://stackoverflow.com/questions/3860280/sql-insert-into-multiple-tables-in-one-query) — VolkerK, Sep 04 '13 at 08:32

score 1 · Answer 1 · edited May 23 '17 at 11:56

1

http://dev.mysql.com/doc/refman/5.0/en/join.html

MySQL supports the following JOIN syntaxes for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements:

You can't use join for INSERT. Sorry.

May I ask , what's the problem with 2 queries?

UPDATE Check @VolkerK 's comment, It offers alternative possible solutions: sql - insert into multiple tables in one query

edited May 23 '17 at 11:56

Community

1
1

answered Sep 04 '13 at 08:34

Ofir Baruch

10,323
2
26
39

Its working...But i just wanted to know that is it possible to use inner join..thats all... – user2745897 Sep 04 '13 at 08:40
So I'm sorry , it's impossible. – Ofir Baruch Sep 04 '13 at 08:41

How to insert different values into two tables with single submit and inner join in MySQL

1 Answers1