There is a plate in Excel. From it you need to add values from several Excel columns to the SQL table. Server - MySql.
1 answer
You can save data from Excel as a CSV, and in MySQL, give the command LOAD DATA INFILE
See this question on SO SO
|
You can save data from Excel as a CSV, and in MySQL, give the command LOAD DATA INFILE
See this question on SO SO
Source: https://ru.stackoverflow.com/questions/598147/
All Articles