LOAD DATA LOCAL INFILE 'c:\userlist.txt' INTO TABLE temp_user
FIELDS ESCAPED BY '\\' TERMINATED BY '\t' LINES TERMINATED BY '\r\n' (`username`, `userid`)
CREATE TABLE tc_userinfo(`username` VARCHAR(100),`ip` VARCHAR(100))
ENGINE = MYISAM DEFAULT CHARSET=utf8
SELECT * FROM tc_userinfo
ORDER BY papertimes DESC
1.关联userid
UPDATE tc_userinfo t ,ol_user u SET t.userid = u.userid WHERE t.username = u.username
/*truncate table ol_ip_tongchao*/
SELECT INET_ATON('123.15.57.50')
SELECT * FROM ol_ip_tongchao WHERE startip<2064595250 AND endip>2064595250
2.ip数据
LOAD DATA LOCAL INFILE 'c:\ip01.txt' INTO TABLE `servant_591up`.`ol_ip_tongchao`
FIELDS ESCAPED BY '\\' TERMINATED BY ',' LINES TERMINATED BY '\r\n' (`startip`, `endip`, `pos`,`detail`)
SELECT COUNT(*) FROM ol_ip_tongchao
TRUNCATE TABLE ol_ip_tongchao
SELECT * FROM ol_ip_tongchao LIMIT 100
SELECT INET_ATON('114.229.74.103')
UPDATE tc_userinfo t ,ol_ip_tongchao i SET t.diqu = i.pos WHERE INET_ATON(t.ip)>=i.startip AND INET_ATON(t.ip)<=i.endip
SELECT * FROM ol_ip_tongchao WHERE INET_ATON('114.229.74.103')
>startip AND INET_ATON('114.229.74.103')< endip
3.
UPDATE tc_userinfo t SET t.racetimes =
(SELECT COUNT(*) FROM gwy_raceresult WHERE userid = t.userid)
4.
UPDATE tc_userinfo t SET t.papertimes =
(SELECT COUNT(*) FROM ol_simulatelog WHERE userid = t.userid)
5.
UPDATE tc_userinfo t SET t.questiontimes =
(SELECT COUNT(*) FROM ol_answerlog WHERE userid = t.userid)
6.
EXPLAIN
UPDATE tc_userinfo t SET t.wrongtimes =
(SELECT COUNT(*) FROM ol_answerlog_tmp WHERE userid = t.userid AND IsCorrect = 0)
UPDATE tc_userinfo t , ol_answerlog l SET t.wrongtimes = 1
WHERE t.userid = l.userid AND l.IsCorrect = 0
CREATE TABLE ol_answerlog_tmp
SELECT * FROM ol_answerlog WHERE userid IN(SELECT userid FROM tc_userinfo)
7.
UPDATE tc_userinfo t SET t.rewrongtimes = ( SELECT
COUNT(*) FROM ol_tc_wrong WHERE userid = t.userid )
9.
UPDATE tc_userinfo t SET t.reviews = ( SELECT
COUNT(*) FROM ol_userreviews WHERE userid = t.userid AND Reviews IS NOT NULL AND Reviews<>'' )
SELECT * FROM ol_userreviews WHERE Reviews IS NOT NULL AND Reviews<>''LIMIT 100
分享到:
相关推荐
CCS gmake CCS gmake CCS gmake
本数据集分为以下29类:A~Z共26个分类、space、nothing、del(每个类别均有2000+张图片) 数据集总大小:323MB 下载解压后的图像目录:训练集(87000张图片)和测试集(28张图片) data-train 训练集-每个子文件夹...
NULL 博文链接:https://neil1222.iteye.com/blog/809678
Java_answers.exe
NULL 博文链接:https://tim1214.iteye.com/blog/1389148
//doc.PrintOut(ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ...
Shared-Nothing MPP Databases with Distributed User-Defined Functions Versus Hadoop/Map-Reduce for Large Data Analytics
概览Apache Geode 是一个数据管理平台,提供实时的、一致的、贯穿整个云架构地访问数据关键型应用.Geode 池化了服务器上的内存, CPU, 网络资源, 和本地磁盘,跨多个进程来管理应用对象和应用行为. 它使用了动态数据...
数据分为以下29类:A-Z共26个英文字母、空格、删除、nothing共29类别(每个类别均有20-30张图片) 数据集总大小:24.1MB 下载解压后的图像目录:训练集(870张图片)和测试集(870张图片) data-train 训练集-每个...
命令交互通道 命名提示符 2. linux 目录结构、文件权限 drwxr-xr-x 3. linux 命令 - 开关机 - 文件操作 - 系统命令 1. top 2. who 3. ifconfig 4. ping 5. kill 6. man 7.clear 8.netstat 4. 软件管理 -...
0、(空字串)、Null、Empty、与 Nothing 的区别
the nuevo for do nothing
nothing_mine.xlsx
nothing no need to see
nothing in particular
NOTHING Flex使用json和xml数据交互
这个系统集合了一个面向列存储的层,一个分布式、shared-nothing的架构,和一个高级的索引结构,来达成在秒级以内对十亿行级别的表进行任意的探索分析。在这篇论文里面,我们会描述Druid的架构,和怎样支持快速聚合...
This function does nothing