EbrahemSamer
3 months ago
472
3
General

what is the best way to insert 1 Million rows using php & mysql?

Posted 3 months ago by EbrahemSamer

I've tried to insert less that 1 M rows using insert like this ..

insert into table (col1,col2,col3) values (val1,val2,val3).......1 M

but but i get http error 500

I tried this using small data and it words fine how can i make it able t do that?

Please sign in or create an account to participate in this conversation.