面朝大海，春暖花开

在操作mysql命令行的时候，很容易会输入错误的单词，这时候只要在当前行后加入\c就可以取消对当前行的编辑mysql> select * from -> fruits wheer\cmysql>

mysql主备(master-slave)搭建环境：mysql5.7.21(master),mysql5.7.20(slave)===========================master server===================mysql> select User,Host from user;+---------------+-----------+| Us

在centos7.3中源码安装mysql-5.7.21获取mysql源码包 mysql-5.7.21.tar.gz<pre class="prettyprint prettyprinted" data-original-code="[root@bogon ~]# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7

mysql实现排名准备工作创建表t_user_score:CREATE TABLE `t_user_score` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL COMMENT '用户ID', `score` int(11) NOT NULL COMMENT...

mysql实现分组取每组中前N条准备工作创建表: CREATE TABLE `t_post` ( `id` int(11) DEFAULT NULL, `tid` int(11) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `message` varchar(255) DEFAULT NULL, `...

行列转换(一)情景一 +----+--------+---------+ | id | month | pay_fee | +----+--------+---------+ | 1 | 201801 | 10 | | 2 | 201802 | 11 | | 3...

行列转换(二)情景一1.有限列类型:+----+----------+-------+--------+| id | fruit_id | color | weight |+----+----------+-------+--------+| 1 | 1 | 红 | 23 || 2 | 1 | 黑 | 54 |...

mysql查询更新项目中经常用到查询结果更新: UPDATE table aINNER JOIN ( SELECT * FROM table WHERE is_delete = 1) b ON a.id = b.idSET a.is_delete = 0...