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

Format timestamp from mysql
When I tried this:
Code: date("m/d/Y H:i A", $row['timestamp'])
I got 12/31/1969 18:

Price in PR
Dear Experts,
Why we have to enter the price in the PR, and why there is no free goods indicato

how to remove in php string display
My code is $message="We're looking at developing our website."; $body= "My mess

Need help urgant
why down my code ony return one item instead of all the items selected.

$arr = array($date,$

Help Import Animoto and Youtube
CAn someone help me urgently want to allow users on my website to import youtube/revver/dailymotion

SESSION question
I am building an application , a directory for auctions.
For SEO i made a script which copies a p

Login Functionality Working Different on IE
This is an odd one, I have a site which has an admin section. The admin pages unsurprisingly require

bit of help needed
Im about to sort out my registration page for my website by customising a "registration" s

Why doesn't this work? (SSH2)
This is my script:

Code: <?php
$connection = ssh2_connect('213.251.167.109', 22);

Find only certain URLs from page ... regex (semi-complete script)
Hi guys,

What I need to do is take a page & extract all the URLs from the page &a