mysql 自我练习基础 7：导入数据表方法

show variables like '%secure%';-- 查看安全路径，随后将表格粘贴到该安全路径下，
    
load data infile "C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/dw_v_order_base.csv" -- shift+右键 选择要导入的数据表然后选择 Copy as path，将"\"修改为"/"

into table dw_v_order_base fields terminated by ','

lines terminated by '\r\n' 
ignore 1 lines; 

select * from dw_v_order_base limit 10;