Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Replace Mysql Statement

Example of Replace Mysql Statement:

REPLACE INTO T SELECT * FROM T;

SELECT Replace('SQLTeam.com Rocks!', 'Rocks', 'Rolls')

SELECT Replace('SQLTeam.com Rocks!', 'Yak', 'Tibetan bison')

UPDATE dbo.authors
SET city = replace(city, 'Salt', 'Olympic')
WHERE city LIKE 'Salt%';

Example of Mysql Show Slave Hosts


REPLACE [LOW_PRIORITY | DELAYED]
[INTO
] tbl_name [(col_name,...)]
{VALUES | VALUE} ({expr | DEFAULT},...),(...),...

Or:
REPLACE [LOW_PRIORITY | DELAYED]
[INTO
] tbl_name
SET col_name={expr | DEFAULT}, ...

Or:
REPLACE [LOW_PRIORITY | DELAYED]
[INTO
] tbl_name [(col_name,...)]
SELECT ...