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

No comments posted yet

Your Answer:

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

RSS feed - FeedList for WordPress
Hi,

I'm trying to alter the FeedList plugin for WordPress so that I can click on the title of

mysql timestamp manipulation
How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

from

frame help
on the bottom frame is menu.html

Code: <body><form action='link.php' met

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag

preg_match logical error
Code: <?php
$s = file_get_contents("page.html");
preg_match('/<div cla

Read from forum
Haven't written anything forever and I would like to get back.
What I'm trying to do is getting t

help, header() is not working!
Hello, I have this code:


<?php

/**
* @author samoi
* @copyright 200

FROM_UNIXTIME($phpdate);
Hello,

I tried to use this :

$date = FROM_UNIXTIME($phpdate);

ANd I was t

chat
hello i'm amir i need a chat source code in asp.net 2.0 without Ajax. anybody can help me?

why does my session end?
my connect.php starts the session just so you know
i can navigate arround my site fine except whe

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