Latest Articles
服务器 MySQL 添加utf8mb4编码配置
SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';# read_rnd_buffer_size = 2Mdatadir=/var/lib/mysqlsocket=/...
Read more »部分表的访问限制
CREATE USER 'new_user'@'%' IDENTIFIED BY 'new_password';将 'new_user' 替换为你想要创建的新用户名，将 'new_password' 替换为你想要设置的新密码。 % 通配符表示允许从任意主机连接。授予新用户访问特定表的权限。使用以下命...
Read more »一些常用的sql
select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where (jian like BINARY '%玄' or zi like BINARY '%玄%') ;select id,zi,zi2,jian,jian2,key1,yin,...
Read more »LSM存储引擎
LSM 是指 Log-Structured Merge-Tree，是一种常用的存储引擎设计。LSM 存储引擎是为了解决传统数据库引擎在写入操作上的低效率问题而设计的。它的核心思想是将数据分成不可变的排序文件存储，从而将随机写转化为顺序写。主要有以下特点：高效的写入操作写入操作先将数据存储在内存中的内...
Read more »mysql myisam innodb data info 3
this "0,3550,2400,4230,2390,4220,238The data you provided appears to be a list of numbers in the format ,. However, without further context or informa...
Read more »mysql myisam innodb data info 2
InnoDB in MySQL can have both the .ibdata1 file and individual .ibd files for tables. Here's the difference between them:.ibdata1: The .ibdata1 file i...
Read more »mysql myisam innodb data info 1
The mysqladmin.exe and mysqld.exe are two different executables that are part of the MySQL database management system. Here's a brief explanation of e...
Read more »mysql max_allowed_packet
1 SET GLOBAL max_allowed_packet = ; but dont work when reboot;2 modify the my.ini ,add the line max_allowed_packet=50M then work;
Read more »mysql 设置远程访问
mysql 设置远程访问1、进入安装目录 MySQL/MySQL Server 5.7/bin【存放mysqld.exe目录】下，运行cmd窗口2、进入MySQL ：命令：mysql -u root -p按照提示输入密码;3、运行mysql命令：use mysql3-1、查询用户表 命令：sele...
Read more »