crac

导航

随笔分类 -  db

linux重启mysql无法启动
摘要：如VPS新建后,重启则无法启动,出现类似 1.查看*.err文件检查报错信息 2.缺少errmsg.sys文件，将源码包里面的sql/share/english/errmsg.sys复制到/usr/share/mysql/errmsg.sys 3.关闭错误日志 参考： https://yq.aliy 阅读全文

posted @ 2017-01-05 23:15 crac 阅读(350) 评论(0) 推荐(0)

数据库Mark.2
摘要：select count(*) as count,DATE_SUB('2016-10-04',INTERVAL regDay DAY) from result_1005 group by DATE_SUB('2016-10-04',INTERVAL regDay DAY) ORDER BY COUNT desc 阅读全文

posted @ 2016-10-06 00:08 crac 阅读(95) 评论(0) 推荐(0)

数据库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 n... 阅读全文

posted @ 2016-10-03 19:42 crac 阅读(164) 评论(0) 推荐(0)