How insert multiple rows in MySQL excel?
How insert multiple rows in MySQL excel? Save your Excel data as a csv file (In Excel 2007 using Save As) Check the saved file using a text editor such as Notepad to see what it actually looks like, i.e. what delimiter was used etc. Start the MySQL Command Prompt. use below script. LOAD DATA […]