为日常加载创建一个虚拟表

Create a dummyTable for daily load

在开始之前清除

将您的excel保存在相同的列结构
中，以csv格式的dummyTable，逗号分隔

Save your excel in same column structure as dummyTable in csv format, comma delimited

运行：

LOAD DATA INFILE '/path/theFile1.csv' 
INTO TABLE dummyTable
    FIELDS TERMINATED BY ',' 
           OPTIONALLY ENCLOSED BY '"'
    LINES  TERMINATED BY '\n'

继续使用它（dummyTable）。清除它。

Proceed to use it (dummyTable). Clear it.