mysql常用命令

向mysql中导入数据

load data infile '/var/lib/mysql-files/1111.csv'

into table student

fields terminated by ','  lines terminated by '\r\n'  (name,class,score) ;