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 =
(SELECT col1,col2 FROM tab1 WHERE id = 141 and status='a')
where co_id=141;

Thanks

Your Answer:

Login to answer

Other forums

how to get different value in second view of webdynpro?
hello guys,

In ABAP webdynpro I am trying to create one application having two views.

Create PHP table grid help, please
I have a MySQL database setup, now it's time for the table (gridview) design in php. Here's the prob

Read from a text file after a specific word
Hi all.

I have a text file that looks like the one below.
I know how to open the text fi

UDP server recvfrom() always returns -1? :(
Hello all,
I am getting a very strange error in my code :( I am writing a server application in C

FlashVar function how to insert variables
Hi guys. Im new in this forum and also new in php programming. Can you help me about this code?
<

Creating XML with php
I need to creat an XML with php and have successfully produced a valid output.
The problem I hav

shoping cart issues
i´ve wrote this and works when i add an item to, my cart, but when i want to add othrer item just

Giving the below syntax error
Dear Experts,

I have used 2 buttons in gui status as display and cjhange.When the user wi

phpmailer class & pop.gmail.com?
Code: <?php
$mail->IsSMTP();
$mail->Host = "pop.gmail.com";

Pagination
Okay here is the page in question: http://blenderteachings.000a.biz/tutorials.hamishhill.php