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 ?
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.
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
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 ?
Once it is saved in table u can just run the select unique query
@@jinujawad ok
, how to read huge number of records without hanging.
You can load huge data using CMD.
its awesome bro but i have 100045 record remaining 45 what can i do
thank you for uploading this video. and how to insert those remaining data in to table?
how to add in multiple table with same file?????
It helped. Thanks
Thanks Bro
If I have 1,030 rows, how can we import that ?
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.