update 2 columns by doing inner 2-column query


Posted on 16th Feb 2014 07:03 pm by admin

Hi,
is something like this possible?

update contract_all set col1,col2 =
Did you know?Explore Trending and Topic pages for more stories like this.
(SELECT col1,col2 FROM tab1 WHERE id = 141 and status='a')
where co_id=141;

Thanks
No comments posted yet

Your Answer:

Login to answer
277 Like 33 Dislike
Previous forums Next forums
Other forums

Table Control
Hi Guru's,

I've created a Module pool program, which contains the Table Control.

Javascript or not?
How many people prefer javascript/ajax sites? How many prefer the good old fashion straight php sit

Structure Question - One Table or One Table Per Record Set?
I have a web app (mySQL and PHP) which allows people to create an item with up to 200 records which

Mysql error message
help me find out what this error message means:

"Duplicate entry '0' for key 'PRIMARY'&q

how to query data from website using VC?
I want to query some datum from a website,so I need a program to read data from a .csv file, and ass

Significance of BPM
Hi Experts,
I am a novice in BPM , I just want to know how BPM as permenant department is

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

Customizing message/behavior
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli

use an array from 1 class in a second class
I have a class that adds data to an array

Then I have a second class and I need to check if t

Why is the logic of this simple code not working?
Hey, I'm trying to determine if a table already exists in mysql, but doing a query first with mysql_

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash