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

统计时间

摘要：CREATE TABLE `TEST` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'g3用户ID', `order_no` varchar( 阅读全文

posted @ 2018-09-07 18:06 papering 阅读(332) 评论(0) 推荐(0)

select version();desc mysql.user;

摘要：D:\wamp64\wamp\bin\mysql\mysql5.6.17\bin>mysql -hgoDev -uroot -ppasswordWarning: Using a password on the command line interface can be insecure.ERROR 阅读全文

posted @ 2018-08-05 17:08 papering 阅读(689) 评论(0) 推荐(0)

mysql user password plugin

摘要：caching_sha2_passwordcaching_sha2_passwordcaching_sha2_passwordcaching_sha2_passwordcaching_sha2_passwordmysql_native_password D:/webCodeOnline/src/ve 阅读全文

posted @ 2018-08-05 16:46 papering 阅读(1227) 评论(0) 推荐(0)

Please read "Security" section of the manual to find out how to run mysqld as root!

摘要：[root@test ~]# /usr/local/mysql/bin/mysqld2018-08-05T08:29:05.143142Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic 阅读全文

posted @ 2018-08-05 16:33 papering 阅读(1815) 评论(0) 推荐(0)

IP address could not be resolved: Name or service not known

摘要：[root@test ~]# /usr/local/mysql/bin/mysqld2018-08-05T07:00:33.647509Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic 阅读全文

posted @ 2018-08-05 15:12 papering 阅读(2577) 评论(0) 推荐(0)

6.5.1.3 Caching SHA-2 Pluggable Authentication

摘要：MySQL :: MySQL 8.0 Reference Manual :: 6.5.1.3 Caching SHA-2 Pluggable Authentication https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-a 阅读全文

posted @ 2018-08-05 14:47 papering 阅读(163) 评论(0) 推荐(0)

ALTER USER USER() IDENTIFIED BY 'password';

摘要：[root@test mysql]# bin/mysqld 2018-08-04T14:09:33.831318Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or e 阅读全文

posted @ 2018-08-04 22:34 papering 阅读(5753) 评论(0) 推荐(0)

写操作，尽量走主键最小化锁粒度

摘要：Wed, 25 Jul 2018 16:01:18 chkMysqlFromOssUdpDB.py[line:185] INFO [UDP-OK][thread:140010784782144][process:25702]Wed, 25 Jul 2018 16:01:18 chkMysqlFrom 阅读全文

posted @ 2018-07-25 15:27 papering 阅读(248) 评论(0) 推荐(0)

锁粒度 Deadlocks

摘要：锁粒度 MySQL :: MySQL 5.7 Reference Manual :: 14.5.2.4 Locking Reads https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html MySQL :: MySQL 8.0 阅读全文

posted @ 2018-07-25 13:48 papering 阅读(147) 评论(0) 推荐(0)

分区测试分区本质

摘要：D:\wamp64\wamp\bin\mysql\mysql5.6.17\bin>mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.17 MySQL Community Server (GPL) Copyr... 阅读全文

posted @ 2018-07-24 21:38 papering 阅读(251) 评论(0) 推荐(0)

SELECT INSTR(120,0000); 真

摘要：sql 排故 SELECT INSTR(120,0000); 真阅读全文

posted @ 2018-07-16 15:17 papering 阅读(171) 评论(0) 推荐(0)

MySQL 5.7 Keywords and Reserved Words

摘要：https://dev.mysql.com/doc/refman/5.7/en/keywords.html#keywords-5-7-detailed-T 阅读全文

posted @ 2018-06-12 20:27 papering 阅读(159) 评论(0) 推荐(0)

分区

摘要：mysql 阅读全文

posted @ 2018-06-05 14:49 papering 阅读(133) 评论(0) 推荐(0)

部门工资最高的员工前3高的员工

摘要：部门工资最高的员工 - LeetCode (中国) https://leetcode-cn.com/problems/department-highest-salary/description/ SELECT d11.Department AS Department,e11.Name AS Empl 阅读全文

posted @ 2018-05-28 13:13 papering 阅读(337) 评论(0) 推荐(0)

连续出现的数字

摘要：连续出现的数字 - LeetCode (中国) https://leetcode-cn.com/problems/consecutive-numbers/description/ Write a SQL query to find all numbers that appear at least t 阅读全文

posted @ 2018-05-27 23:27 papering 阅读(231) 评论(0) 推荐(0)

What’s New in MySQL 8.0? (Generally Available) 新特性

摘要：原创｜InnoDB事务锁系统及其实现 https://mp.weixin.qq.com/s/W07ZIW0GRtsrS5nuiy2z_A CATS事务调度算法 CATS(Contention Aware Transaction Schedule)是MySQL 8.0的一个新特性，相关论文发表在VLD 阅读全文

posted @ 2018-05-26 01:16 papering 阅读(296) 评论(0) 推荐(0)

创建函数与调用函数

摘要：第N高的薪水 - LeetCode (中国) https://leetcode-cn.com/problems/nth-highest-salary/description/ Write a SQL query to get the nth highest salary from the Emplo 阅读全文

posted @ 2018-05-25 21:07 papering 阅读(229) 评论(0) 推荐(0)

超过经理收入的员工表的自JOIN

摘要：https://leetcode-cn.com/problems/employees-earning-more-than-their-managers/description/ The Employee table holds all employees including their manage 阅读全文

posted @ 2018-05-25 02:17 papering 阅读(240) 评论(0) 推荐(0)

CASE UPDATE

摘要：https://leetcode-cn.com/problems/swap-salary/description/ Given a table salary, such as the one below, that has m=male and f=female values. Swap all f 阅读全文

posted @ 2018-05-25 02:11 papering 阅读(247) 评论(0) 推荐(0)

取余数

摘要：SELECT * FROM cinema WHERE description NOT IN ("boring") AND id MOD 2 = 1 ORDER BY rating DESC 阅读全文

posted @ 2018-05-25 01:59 papering 阅读(205) 评论(0) 推荐(0)

papering

随笔分类 - mysql