SQL Bulk Insert is not a new technology. In fact, I've used it since SQL Server 6.5., when it was a very cumbersome implementation from Microsoft that required a great deal of preparation of the Bulk ...

Form your initial insertion query, such as "INSERT INTO your_table (column1,column2) VALUES ('1','a');" Alter the query by adding a rule for what to do if a duplicate key is found, such as "INSERT ...

You should see the data listed (Figure A). Figure A Continue adding data to the table in the same fashion. And that’s all there is to creating a table and inserting data into it on MySQL.