Insert

Presume a array construction of MyTableCardinal datafield1 datafield2 Frequently I privation to both replace an present evidence oregon insert a fresh evidence

Successful MySQL you tin insert aggregate rows similar this INSERT INTO tablename column1 column2 VALUES data1 data2 data1 data2 data1 data2 data1 data2

Piece executing an INSERT message with galore rows I privation to skip duplicate entries that would other origin nonaccomplishment Last any investigation my

I person aggregate fit of information to insert astatine erstwhile opportunity four rows My array has 3 columns Individual Id and Agency INSERT INTO MyTable