INSERT Statement

参考链接： https://dev.mysql.com/doc/refman/8.0/en/insert.html https://www.docs4dev.com/docs/zh/mysql/5.7/reference/insert.html

语法

1
2
3
4


INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] _tbl_name_ [PARTITION (_partition_name_ [, _partition_name_] ...)] [(_col_name_ [, _col_name_] ...)] { {VALUES | VALUE} (_value_list_) [, (_value_list_)] ... } [AS _row_alias_[(_col_alias_ [, _col_alias_] ...)]] [ON DUPLICATE KEY UPDATE _assignment_list_] 
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] _tbl_name_ [PARTITION (_partition_name_ [, _partition_name_] ...)] SET _assignment_list_ [AS _row_alias_[(_col_alias_ [, _col_alias_] ...)]] [ON DUPLICATE KEY UPDATE _assignment_list_] 
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] _tbl_name_ [PARTITION (_partition_name_ [, _partition_name_] ...)] [(_col_name_ [, _col_name_] ...)] { SELECT ... | TABLE _table_name_ | VALUES _row_constructor_list_ } [ON DUPLICATE KEY UPDATE _assignment_list_] 
_value_: {_expr_ | DEFAULT} _value_list_: _value_ [, _value_] ... _row_constructor_list_: ROW(_value_list_)[, ROW(_value_list_)][, ...] _assignment_: _col_name_ = _value_ | [_row_alias_.]_col_name_ | [_tbl_name_.]_col_name_ | [_row_alias_.]_col_alias_ _assignment_list_: _assignment_ [, _assignment_] ...

INSERT Statement

语法

常用参数

默认值