REPLACE 命令

 

语法:

REPLACE [LOW_PRIORITY | DELAYED]

   [INTO] tbl_name [(col_name,...)]

   VALUES (expression,...),(...),...

REPLACE [LOW_PRIORITY | DELAYED]

   [INTO] tbl_name [(col_name,...)]

   SELECT ...

REPLACE [LOW_PRIORITY | DELAYED]

   [INTO] tbl_name

   SET col_name=expression, col_name=expression,...

参数:

参数 意义
LOW_PRIORITY 低优先级,等到表空闲时执行
DELAYED 命令提前返回,等表空闲时执行命令