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 + + Column2
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 from merging 2
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 Column3 =
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 the
