Insert data more than 7000000 record in 1 minutes in database(superfast query with calculation)

$file = $this->root_path.‘Gsync.csv’;
mysqli_query($consLOAD DATA LOCAL INFILE “‘.$file.‘”
        INTO TABLE your_table_name
        FIELDS TERMINATED by \’,\’
        LINES TERMINATED BY \’\n\’
        IGNORE 1 LINES
        (isbn13,price,discount,free_stock,report,report_date);

Leave a Reply

Your email address will not be published. Required fields are marked *