inserting multiple values in one shot and checking for duplicate at the same time

Question

hello all i am inserting my data by this query

insert into doc_share (docid,did,coid,eid) values 
('$val','$some','$thing','$here'),
('$val25','$some','$thing','$here'),
('$val33','$some','$thing','$here')...
// only $val is changing other values are same

now in my database i want unique combination of docid and did i have done it from by table but i want to do it by query because even when there is one duplicate row no insertion of rows are done even for non duplicate rows.

i want to do the checking for any duplicate rows before sending the data to database if possible withing the same query

please give me some hints ....

This is one query, this isn't multi-querying. Is `docid` not auto-incrementing? — chris85, Aug 04 '15 at 03:20
oo `did` is a field not the word.. is `did` = `$some`? You have 4 values but 5 columns.. — chris85, Aug 04 '15 at 03:26
yes did is a field not a word and i am sorry i edited the code 4 values 4 columns ..:) — Rahul aman, Aug 04 '15 at 03:31
i just need to check the combination of docid and did to be unique docid can be anything but did is same — Rahul aman, Aug 04 '15 at 03:33

score 1 · Accepted Answer · answered Aug 04 '15 at 04:29

1

insert IGNORE into doc_share (docid,did,coid,eid) values 
('$val','$some','$thing','$here'),
('$val25','$some','$thing','$here'),
('$val33','$some','$thing','$here')...

answered Aug 04 '15 at 04:29

M0rtiis

3,535
1
12
22

it will still increment the auto incremented field .. – sonam Sharma Aug 04 '15 at 06:33
there is no "proper" way to not increment autoincrement-field. Forget about it. Somthing wrong with your app-logic if you want to do that – M0rtiis Aug 04 '15 at 06:37

inserting multiple values in one shot and checking for duplicate at the same time

1 Answers1