mysql - 随笔分类(第10页) - papering

redo binlog 实践 Binary Logging Formats

摘要：实践 1）开启binlog 1、 vim /etc/mysql/mysql.cnf添加 # binlog 配置log-bin = /var/log/mysql/mysql-bin.logexpire-logs-days = 14max-binlog-size = 500Mserver-id = 1 阅读全文

posted @ 2017-04-15 15:38 papering 阅读(174) 评论(0) 推荐(0)

mysqld.sock

摘要：sudo service mysql start https://dev.mysql.com/doc/refman/5.7/en/problems-with-mysql-sock.html B.5.3.6 How to Protect or Change the MySQL Unix Socket 阅读全文

posted @ 2017-04-13 14:15 papering 阅读(218) 评论(0) 推荐(0)

SET NAMES 'charset_name'

摘要：设置写入db和db返回读出结果的字符集character set https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html SET NAMES 'charset_name' [COLLATE 'collation_name'] S 阅读全文

posted @ 2017-04-10 09:58 papering 阅读(186) 评论(0) 推荐(0)

summary

摘要：summary 阅读全文

posted @ 2017-04-07 08:31 papering 阅读(148) 评论(0) 推荐(0)

淘宝数据库3方面

摘要：w 阅读全文

posted @ 2017-03-28 06:01 papering 阅读(166) 评论(0) 推荐(0)

Character Sets, Collation, Unicode :: utf8_unicode_ci vs utf8_general_ci

摘要：w Hi, You can check and compare sort orders provided by these two collations here: http://www.collation-charts.org/mysql60/mysql604.utf8_general_ci.eu 阅读全文

posted @ 2017-03-22 10:48 papering 阅读(210) 评论(0) 推荐(0)

Aggregate (GROUP BY) Function Descriptions

摘要：w Table 13.25 Aggregate (GROUP BY) Functions NameDescription AVG() Return the average value of the argument BIT_AND() Return bitwise AND BIT_OR() Retu 阅读全文

posted @ 2017-02-22 10:25 papering 阅读(177) 评论(0) 推荐(0)

日期格式日期运算 mysql 时间时间戳字符串转time.struct_timed 转datetime 时间差计算取出日期所在的周的周一的日期

摘要：时间消耗耗时 import timefrom datetime import datetimelimit_ms = 10000start = datetime.now()time.sleep(1.234)end = datetime.now()duration = end - startms = 阅读全文

posted @ 2017-02-17 02:35 papering 阅读(1325) 评论(0) 推荐(0)

选出ip记录表最近的10行数据

摘要：w 阅读全文

posted @ 2017-02-16 22:49 papering 阅读(197) 评论(0) 推荐(0)

the ONLY_FULL_GROUP_BY SQL mode is enabled (which it is by default) 用户变量

摘要：实践： 1）首先，可以先查看一下数据库现在的sql_mode的值，sql语句为： select version(), @@sql_mode; 获取结果可能如下，不同的设置查询出来的有区别：然后可以使用如下语句，去设置自己需要的sql_mode. SET sql_mode=(SELECT REPL 阅读全文

posted @ 2017-02-16 15:32 papering 阅读(291) 评论(0) 推荐(0)

mysql 浏览器submit中文， shell乱码

摘要：w控制变量法。初始浏览器submit中文成功执行问题仍未解决执行 SET character_set_database='latin1'; 再执行 SET character_set_results='utf8'; 问题解决,shell不再乱码 https://dev.mysql.com/ 阅读全文

posted @ 2017-02-07 14:20 papering 阅读(218) 评论(0) 推荐(0)

导入导出

摘要：MySQL Server 5.6\bin 第二步：执行mysql/bin目录的mysqldump备份数据库命令：mysqldump -h127.0.0.1 -u**** -p --default-character-set=utf8 test >D:\Test.sql 命令解析： --defaul 阅读全文

posted @ 2017-02-07 13:51 papering 阅读(190) 评论(0) 推荐(0)

mysql json

摘要：JSON_CONTAINS(CategoryIdSet,"172") [123,17,2] N [172,12] Y [172,12] Y SELECT name, profile->"$.twitter" AS `twitter` FROM `user` WHERE profile->"$.twi 阅读全文

posted @ 2017-02-07 13:18 papering 阅读(175) 评论(0) 推荐(0)

mysql IPv4 IPv6

摘要：w如何通过一个mysql方法，而不是借助脚本判断？INET6_ATON(expr) https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_inet-aton https://dev.mysql.co 阅读全文

posted @ 2017-01-24 17:05 papering 阅读(518) 评论(0) 推荐(0)

UNION WHERE

摘要：w条件语句的作用域。阅读全文

posted @ 2017-01-23 14:21 papering 阅读(262) 评论(0) 推荐(0)

UNION DISTINCT

摘要：w同结构表读写合并。阅读全文

posted @ 2017-01-21 23:39 papering 阅读(411) 评论(0) 推荐(0)

联合约束 CONCAT()

摘要：w SELECT 原理。 wz id wint wchar 15 115 115wz16 116 116wz1 1001 1001wz2 1002 1002wz3 1003 1003wz4 1004 1004wz5 1005 1005wz6 1006 1006wz7 1007 1007wz8 100 阅读全文

posted @ 2017-01-21 10:52 papering 阅读(322) 评论(0) 推荐(0)

怎样合并分支条件，减少代码行数？

摘要：w怎样合并分支条件，减少代码行数？ ERROR 阅读全文

posted @ 2017-01-20 16:03 papering 阅读(295) 评论(0) 推荐(0)

INFORMATION_SCHEMA.STATISTICS 统计表库大小

摘要：INFORMATION_SCHEMA MySQL :: MySQL 5.5 Reference Manual :: 21 INFORMATION_SCHEMA Tables https://dev.mysql.com/doc/refman/5.5/en/information-schema.html 阅读全文

posted @ 2017-01-20 10:29 papering 阅读(817) 评论(0) 推荐(0)

wcur LOCATE +

摘要：w字符串处理阅读全文

posted @ 2017-01-18 10:43 papering 阅读(244) 评论(0) 推荐(0)

papering

随笔分类 - mysql