Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MySQL
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?
 
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 27-Feb-13 19:44pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  
Comments
project virus at 28-Feb-13 1:45am
   
Can't I do it by using JOIN?
Shubhashish_Mandal at 28-Feb-13 2:15am
   
In this case you can't.
kimberly wind at 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)

  Print Answers RSS
0 OriginalGriff 304
1 Sergey Alexandrovich Kryukov 255
2 Shweta N Mishra 216
3 Maciej Los 210
4 PIEBALDconsult 174
0 OriginalGriff 7,660
1 Sergey Alexandrovich Kryukov 7,072
2 DamithSL 5,586
3 Manas Bhardwaj 4,946
4 Maciej Los 4,665


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 28 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100