数据库mark
时间：2021-07-01 10:21:17
帮助过：2人阅读
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)
数据库mark
标签：
