Insert 1 milion record |
(11-07-2017, 08:42 AM)omid_student Wrote:(09-29-2017, 02:17 PM)ciadvantage Wrote:(09-29-2017, 01:31 PM)omid_student Wrote:(09-29-2017, 01:25 PM)ciadvantage Wrote: Well if ID is primary key then it should be auto-incremented as you set it, so it is taken care off already. Your example is like The best way is using MySQL Tools like MySQL Workbench, Navicat, SQLyog to do the Import / Export.
I second the use of mysql's load data infile. I worked on a project once where they with dealing with millions of rows of data reqularly, with data normalization, etc. We handled that by using load data to load the CSV to a temporary table at which point we could removed duplicates, normalize, etc. before merging into the rest of the working data. Worked pretty well.
|
Welcome Guest, Not a member yet? Register Sign In |