EXECL data import in MySQL

Because there are too many classifications, it is not possible to replicate one by one and import categorical data into Ecshop's

The Ecs_category table. 1. Make the same structure as the Ecs_catergory table data, and encounter problems in this process, the A.EXECL data value is the same value? Using the shortcut key Ctrl+d can achieve the same number of rows of data B. Occupy multiple rows of data and turn it into a single row. Copy the column from execl and paste it into a new. txt processing. C. Automatically fill the number of digits in order the mouse is placed in the lower-right corner of the cell, and a cross-fill handle appears, and a drop-down is available. D. Removing duplicate rows Remove E.word Documents by AutoFilter remove blank lines http://jingyan.baidu.com/article/a3a3f811a4c0608da2eb8a24.html

F. Selecting data fragments from a column of data from EXECL

=left (a1,1) Next import process See http://blog.163.com/dielianjun%40126/blog/static/164250113201042310181431/

EXECL data import in MySQL