Andrew Kuebler wrote:
How would I write an UPDATE query to SET Column3 to "John Doe" without
selecting the information and reposting it to the data through an UPDATE
for each and every record?
You'll probably have to do a SELECT query into a temporary table, then a
REPLACE INTO to fill in th
Andrew Kuebler wrote:
If Column1 has a value of "John" And
Column2 has a value of "Doe"
How would I write an UPDATE query to SET Column3 to "John Doe" without
selecting the information and reposting it to the data through an UPDATE
for each and every record?
I've tried:
UPDATE $table SET Column
UPDATE $table SET Column3 = CONCAT(Column1," ",Column2);
http://www.mysql.com/doc/en/String_functions.html#IDX1162
-Original Message-
From: Andrew Kuebler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 12:45 PM
To: [EMAIL PROTECTED]
Subject: UPDATE 1 Column fr
If Column1 has a value of "John" And
Column2 has a value of "Doe"
How would I write an UPDATE query to SET Column3 to "John Doe" without
selecting the information and reposting it to the data through an UPDATE
for each and every record?
I've tried:
UPDATE $table SET Column3 = Column1 + " " + Col