导入csv数据到database(Windows版命令行导入): 1.配置文件添加 secure_file_priv = C:/Users/XXX/Desktop(路径,我填的是桌面的路径) 2. loaddata infile 'C:/Users/XXX/Desktop/xxwopcb201821.csv' into table xxwopcb fieldsterminated by ',' optionally enclosed by '"' escaped by '"' ;(导入命令)
导入csv数据到database(Windows版命令行导入): 1.配置文件添加 secure_file_priv = C:/Users/XXX/Desktop(路径,我填的是桌面的路径) 2. loaddata infile 'C:/Users/XXX/Desktop/xxwopcb201821.csv' into table xxwopcb fieldsterminated by ',' optionally enclosed by '"' escaped by '"' ;(导入命令)