SELECT distinct phone time FROM 数据.new_table;
select phone,time from 数据.new_table group by phone;
解决方法:将CSV文件放到mysql的安全目录uploads文件夹下
load data infile 'E:/xxx/data.csv' into table 数据.new_table fields terminated by ',' optionally enclosed by '"' escaped by '"'lines terminated by '\r\n'