set Column value with select statement

bobwilli · #1 (**permalink**) 11-13-03, 12:15

Is there a way to set the value for a particula column data using only SELECT statement?

ex.
update TABLE set COLUMN = value where COULMNX = value ;

instead of this, I need to use only a SELECT statement to do the same function.

aus · #2 (**permalink**) 11-13-03, 15:03

Use REPLACE, the trick is that you must have a primary key or a unique index on the table. This command will replace rows with the same unique index or insert the row like normal. You can use it just like an INSERT.

Quote:

Originally posted by bobwilli
Is there a way to set the value for a particula column data using only SELECT statement?

ex.
update TABLE set COLUMN = value where COULMNX = value ;

instead of this, I need to use only a SELECT statement to do the same function.

khibinite · #3 (**permalink**) 11-17-03, 09:38

Quote:

Originally posted by aus
Use REPLACE, the trick is that you must have a primary key or a unique index on the table. This command will replace rows with the same unique index or insert the row like normal. You can use it just like an INSERT.

Oh, that's great, I didn't kow about this function

.

Internet Services

Web Development

Digital Marketing

Consumer Tech