数据库mark
LOAD DATA INFILE 'I:\QQpwd\\1.txt' IGNORE INTO TABLE sgk.top1 FIELDS TERMINATED BY '----' OPTIONALLY ENCLOSED BY '' ESCAPED BY '\\' # LINES TERMINATED BY '----' #IGNORE number LINES #(QQnum,QQpass,QQip,addr,QQdate,QQtime); select count(qqpass) as count,qqpass from sgk.top1 group by qqpass having count(qqpass)>6 order by count(qqpass)