Loading

Insert and Update in single mysql query

Akshay Homkar

13y1.9kPHP

Hello

I like to know that shall we insert and update the information in to two different tables in MySQL using single query in PHP please give one example

please help

awaiting for your valuable reply

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akshay Homkar13y ago
thanks for reply sir. please give me one example I have two tables one inventory and second inventorymast in inventory I am updating the values and in inventory mast I like to insert the upadated values form inventory when I am filling up the form. awiting your valuable reply
0
Sreejesh SP13y ago
Dear Akshay,

          Table1(id int pk identity=true,name)

           Table2(add int pk identity=true,id,address)

         insert into table1(name)
                       values("hari")

         Declare @id numeric(18,0)

           set @id=@@identity

           inert into table2(id,address)
                        values(@id,"ekm")

Thanks

Sreejesh

0