数据库mark
标签：
数据库mark
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)