语法:
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)] VALUES ((expression | DEFAULT),...) , (...), ... [ ON DUPLICATE KEY UPDATE col_name=expression, ... ] |
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)] SELECT ... |
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name SET col_name=(expression | DEFAULT), ... [ ON DUPLICATE KEY UPDATE col_name=expression, ... ] |
参数:
参数 | 意义 |
---|---|
LOW_PRIORITY | 低优先级,等到表空闲时执行 |
DELAYED | 低优先级,同上,但立即返回不等待 |
IGNORE | 重复值冲突时忽略,不发生错误 |
DEFAULT | 指定使用表的默认值 |
ON DUPLICATE KEY UPDATE | 插入不允许重复的值时,产生更新效果 |
SELECT ... | 一个查询语句,查询结果插入表,字段应匹配 |