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

help with insert
Hi there,

I am trying to insert some data into a database, but for some reason, it is not ins

xApp Analytics in BI 7.0
Dear all,

I am trying to implement xApp Analytics in BI 7.0. After I installed the analyt

Stuck with preg_replace
Hi,

I'm trying to use preg_replace to remove part of the IP address submitted using a form on

Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system

Say I go to h

PHP - MySQL Fail
My PHP code will only execute the first part of my code...

Code: <?php

sessio

Windows Authentication
I have a website which is windows authenticated.
now i want something more on this application.<

IF STATEMENT HELP
Hi
i have created a calendar from a table:

Code: Calendar: October 2009
<table w

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '

Question about the upload of large files
Hi there,

I have a question about the upload of large files, like videos (files generally abo

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to