help；
insert ignore；
insert ... on duplicate key update；
update/delete ... order by ... limit ...;
replace into
mysql> \h show
Name: 'SHOW'
Description:
show the value of a run-time parameter
Examples:
SHOW name
SHOW ALL
SHOW DATABASES
SHOW SCHEMAS
SHOW TABLES
SHOW PROCESSLIST
mysql> \h replace
Name: 'REPLACE'
Description:
If the old row in the table has a unique constraint violation with the new row, the old row in the table is replaced; otherwise, the new row is inserted.
Examples:
[ WITH [ RECURSIVE ] with_query [, ...] ]
REPLACE INTO table_name [ AS alias ] [ ( column_name [, ...] ) ]
[ OVERRIDING { SYSTEM | USER} VALUE ]
{ DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [, ...] | query }
[ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]
mysql>
*Issue migrated from trac ticket # 898 www.kunlunbase.com *
component: computing nodes | priority: major
2022-07-12 14:31:23: smith created the issue