Insert 10 million records in MySQL using PHP from CSV file

[@mohamedmafaz8664]

good but have problem, if 1025 record available only its insert 1000 only rest 25 not taking, if its 100125 that time also 10000 record 125 not taking

[@mabrarrubaiyatislam5653]

It helped. Thanks

[@shivaarukonda2640]

thank you for uploading this video. and how to insert those remaining data in to table?

[@mdgaffar]

Fantastic. Tell how to read 6 lakh records each day in MySQL 5.7 and store it in temp table. At month end I need to augment 30 or 31 days report with unique from temp table and produce csv report. How to achieve this ?

[@jinujawad]

Once it is saved in table u can just run the select unique query

[@mdgaffar]

@@jinujawad ok
, how to read huge number of records without hanging.

[@anuragsarkar]

You can load huge data using CMD.

[@vipinchauhan2454]

how to add in multiple table with same file?????

[@Zeee4444]

If I have 1,030 rows, how can we import that ?

[@raimohaikari707]

General aswer would be, that after while-loop ends, check if there is content in subquery - and run final INSERT INTO query before closing db -connection.

[@MohdAsifShah]

Thanks Bro

[@ansari1129]

its awesome bro but i have 100045 record remaining 45 what can i do