You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
help;
insert ignore;
insert ... on duplicate key update;
update/delete ... order by ... limit ...;
replace into
例如查阅show和replace语法
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>
The text was updated successfully, but these errors were encountered:
*Issue migrated from trac ticket # 898 www.kunlunbase.com *
component: computing nodes | priority: major
2022-07-12 14:31:23: smith created the issue
The text was updated successfully, but these errors were encountered: