Click here to Skip to main content
15,071,928 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,
I am having problem to update multiple table with a single value..
Actually have 3 tables named 'imprt','imprt2' and 'temp1'.each table has same field name'tele'
I have to update values of each table...but my query do not work.please can any one help me?

<tag> UPDATE imprt as a,imprt2 as b , temp1 as c SET a.tele = 'd',b.tele = 'd',c.telec = 'd' WHERE a.telec='NEHA' AND b.tele='NEHA' AND c.tele='NEHA'

Posted

1 solution

You can not update multiple tables in single statement.Rather than you can group all updates in a single procedure and execute the procedure within transaction or you can batch up all the updates.
   
Comments
project virus 28-Feb-13 1:45am
   
Can't I do it by using JOIN?
Shubhashish_Mandal 28-Feb-13 2:15am
   
In this case you can't.
kimberly wind 28-Feb-13 4:55am
   
Shubhashish is correct .cant update multiple database same time .only solution is stored procedure

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900