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,qqpassfrom sgk.top1group by qqpass having count(qqpass)>6order by count(qqpass)