Click here to Skip to main content
11,929,675 members (56,060 online)
Rate this:
Please Sign up or sign in to vote.
See more: MySQL
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
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.
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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.151126.1 | Last Updated 28 Feb 2013
Copyright © CodeProject, 1999-2015
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