[RESOLVED] How do you do mysql bulk insert or insert ignore

[Thikho]

I have a script that will fetch account numbers and then list all account which have outstanding invoices after i have fetch those result i need to check thru each result if the invoice is outstanding then i have to insert it to a new table (bulk insert) before i can email it How do i do the insert ignore / bulk insert i mysql
thanks.

[bpat1434]

Separate the values parenthesized items by commas:

INSERT INTO `tablename` (`column`, `column2`, `column3`) VALUES ('value1', 'value2', 'value3'),
('value1', 'value2', 'value3'),
('value1', 'value2', 'value3'),
('value1', 'value2', 'value3');

[Thikho]

in case of mysql can i do something like this

$sql = "INSERT INTO table1
(WaybillNum, UserEmail, TelnetUser, TelnetPasswd, FWpasswd, WaybillDateTime, Signee, AccountNum, OTDretcode, Message, DateStamp, MsgType) VALUES (
'".$data[1]."', '".$data[6]."', 'berscrip', 'Berscrip', '<system var>', '".$data[7]."', '".$data[3]."', '".$podprocess->account."', o, 'Waybill Uploaded Successfully', NOW(), 0)
, 
(
'".$data[1]."', '".$data[6]."', 'berscrip', 'Berscrip', '<system var>', '".$data[7]."', '".$data[3]."', '".$podprocess->account."', o, 'Waybill Uploaded Successfully', NOW(), 0)";

I am getting confused now with mysql/php, the issue here is that i will be fetching a lot of records from one table and on that result i will select invoices which are oustanding then add them on a new table before i can email it (insert ignore in mysql )

hope u find this in order

tnks

[bpat1434]

With duplicate data, no, mySQL will complain if any of your columns are "Unique". Otherwise, you'll have duplicate rows.

If you want more info on insert ignore, read the MySQL manual on it. It's really really descriptive.