db icon indicating copy to clipboard operation
db copied to clipboard

batchInsert support ignore

Open qihuajun opened this issue 7 years ago • 3 comments

When I execute batch inserting into tables with unique index, I hope the batchInsert method of yii\db\Command Class have a argument to specify whether to execute INSERT IGNORE INTO or just INSERT INTO .

qihuajun avatar Apr 23 '17 03:04 qihuajun

INSERT IGNORE itself is MySQL-specific. Need to check if there are similar features in other DBs.

samdark avatar Apr 23 '17 06:04 samdark

related to #5138

cebe avatar Apr 25 '17 20:04 cebe

this is something i would like too but as @samdark said it would break with all databases except for one.

Faryshta avatar Apr 25 '17 21:04 Faryshta