u011913330的专栏

B-tree索引的特点B-tree索引以B+树的结构存储数据在什么情况下可以使用到B树索引全职匹配的查询order_sn='9898989656565'匹配最做前缀的查询匹配列前缀的查询order_sn like '9876%'匹配范围值的查询order_sn > '9874566'order_sn 精确匹配做前列并范围匹配另外一列o

mysql必须开启二进制日志，不开启无法恢复状态的查看：mysql> show variables like '%log_bin%';mysql> show variables like '%log_bin%';+---------------------------------+-------+| Variable_name | Value |+-------------------...

1.先进入服务器数据库>use mysql>grant all privileges on *.* to admin@"%" identified by 'password' with grant option;#创建mysql 远程链接账号2.进入阿里云控制台->云服务ECS->网络与安全->安全组->配置规则->添加安全组规则，授权对象填...

在做group by和order by 数据筛选排序1.数据记录mysql> select id,sn,uid,uid_from,money,created_at from orders where uid_from = 7 and status = 1;+-----+------------------+-----+----------+-------+-----------...