zhsworld的博客

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another.可以先在一个语句中保存用户变量的值，然后再另一个语句中...

一、什么是索引？The best way to improve the performance of SELECT operations is to create indexes on one or more of the columns that are tested in the query. The index entries act like pointers to the table...

一、准备工作1 环境MySQL 5.7.28 + Ubuntu18.04.42 登录MySQL-- Terminal下输入mysql -uroot -p3 数据库操作-- 创建数据库 practice-- character set 用来指定编码格式，方便之后插入中文create database practice character set utf8;-...

目录1 查询前N行2 查询特定列3 查询某列的去重数据4 根据条件筛选数据5 分组计数6 按某列分组后，对其它列进行统计7 横向连接表8 纵向连接表9 分组后排序10 按条件分组11 按条件更新某个值12 按条件删除行13 删除列14 提取/匹配字符串15 替换字符串中字符16 根据某列，对另外一列进行计数1 查询前N行# ...