MySQL 导入数据

MySQL 导入数据是可能遇到 --secure-file-priv 问题，这时修改 my.cnf 中secure-file-priv 为 "",

load data infile 'C:/ProgramData/MySQL/MySQL Server 8.0/data1_processed.txt'
into table dbhw1_2.orders
fields terminated by ' '
lines terminated by '\r\n';