MySql---INSERT的各种用法

插入语句

1、最简单的

INSERT INTO tableName (colNmae1, colName2) VALUES (value1, value2);

2、循环插入

INSERT INTO
    tableName 
    (
    	colNmae1, 
    	colName2
    ) 
    VALUES 
	<foreach collection="list" item="item" open="" close="" separator=",">
	(
		#{item.value1},
		#{item.value2}
	)
	</foreach>

3、主键重复则不插入

INSERT IGNORE INTO tableName (colNmae1, colName2) VALUES (value1, value2);