How to import huge data from excel to MySql

156
April 21, 2018, at 11:25 PM

Today I tried importing 44.555 row from excel files to MySql database using heidiSQL, but why only 1.662 imported to database

two last row in excel

All row result in mysql only 6 x 1.662

What is the maximum number of rows that Mysql can handle?

import window heiSQL

finaly , all 44.554 rows imported to database, open csv file with notepad, save as with encoding utf8 then csv ready to import..

READ ALSO
mysql restrict query types for user on specific tables

mysql restrict query types for user on specific tables

I want to restrict the following types of queries on my db for specific user and specific tables in my dbI am unable to find the right example how to do this

87
phpMyAdmin MySQL register functionality not working

phpMyAdmin MySQL register functionality not working

After running both services: Apache and MySQL, When I try to register with some data, it is actually not pushed into the database which I selectedI mean MySQL Database does not recieves the input from the index

151
Getting json data from MySQL with R

Getting json data from MySQL with R

I am currently learning RI am wondering what would be best way to read data from MySQL server that is in json format? I have MySQL table that has fields: id, time, data

128
php export csv from mysql

php export csv from mysql

i have script that should exportcsv file from database

149