随笔分类 - mysql笔记
摘要：package com.dp.config; import org.springframework.cloud.gateway.filter.GatewayFilterChain; import org.springframework.cloud.gateway.filter.GlobalFilte
阅读全文
摘要：ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
阅读全文
摘要：SELECT id, SUBSTRING_INDEX(SUBSTRING_INDEX(uid, ',', n), ',', - 1) AS idFROM hd_check_plain, (SELECT @rownum := @rownum + 1 AS n FROM (SELECT @rownum
阅读全文
摘要：CONCAT(SUBSTRING(MD5(UUID()),1,8),'-',SUBSTRING(MD5(UUID()),8,4),'-',SUBSTRING(MD5(UUID()),12,4),'-',SUBSTRING(MD5(UUID()),16,4),'-',SUBSTRING(MD5(UUI
阅读全文
摘要：SHOW BINARY LOGS; set global binlog_expire_logs_seconds=60*60*24; show variables like '%expire%'; flush privileges; 永久改动可以找到/etc/mysql/my.cnf（Ubuntu）文
阅读全文
摘要：FIND_IN_SET(str1,str2) 判断str2是否包含str1 例： SELECT a.RWID,a.OVERDUECOUNT,a.STATUS,a.USERID,a.INVESTIGATION_DATE,a.CREATE_DATE CREATE_DATE2,b.* FROM hd_ch
阅读全文
摘要：UPDATE hd_check_plain SET UNAMELIST = REPLACE(REPLACE(UNAMELIST, CHAR(10), ''), CHAR(13), '');UPDATE hd_check_plain SET UNAMELIST = REPLACE(REPLACE(UN
阅读全文
摘要：进入到mysql安装包bin目录下执行此命令 mysqldump -u root -p double_prevention > /home/double_prevention.sql
阅读全文
摘要：登录mysql mysql -u root -p 输入登录密码 使用mysql数据库 USE mysql 修改密码 ALTER USER ‘test’@‘localhost’ IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY ‘新密码’; 验证是否修改成功 mysql
阅读全文
摘要：执行： select * from mysql.user | Host | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_
阅读全文
摘要：SOURCE 文件路径 例：SOURCE /opt/double_preventiont.sql 如果导入数据量大： -- 禁用索引和约束SET autocommit=0;SET unique_checks=0;SET FOREIGN_KEY_CHECKS=0; -- 导入数据SOURCE /pat
阅读全文
摘要：ALTER TABLE person_people MODIFY COLUMN Sex VARCHAR(512);
阅读全文
摘要：先内部使用order by方式排好序+LIMIT 99999999，外层再用group by分组 例如 SELECT a.* FROM (SELECT id,PersonName,TIME,X,Y,Z,createtime FROM person_position ORDER BY TIME DES
阅读全文
摘要：打开my.ini文件，加入：max_allowed_packet=500M 默认大小为1M多，可以根据自己所需的大小设置
阅读全文
摘要：GROUP_CONCAT (name) name。按name条件查询的话加上distinct。不是的话用group by分组
阅读全文
摘要：case:例 CASE WHEN p.hd > 320 THEN '重大风险' WHEN p.hd >= 160 AND p.hd <= 320 THEN '较大风险' WHEN p.hd >= 70 AND p.hd <= 159 THEN '一般风险' ELSE '低风险' END AS fj
阅读全文
摘要：mysql5: grant all privileges on *.* to root@"%" identified by "."; GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT O
阅读全文
摘要：查询时间间隔： DATE(create_time) < DATE_SUB(CURDATE(), INTERVAL 1 DAY); DATE(create_time) < DATE_SUB(CURDATE(), INTERVAL 7 month); createtime < DATE_SUB(NOW(
阅读全文
摘要：创建存储过程简单示例： DELIMITER //CREATE PROCEDURE ccgc()BEGINSELECT * FROM TEXT;SELECT * FROM s_user;END//DELIMITER ; //调用CALL ccgc() 创建带参数的存储过程： DELIMITER //C
阅读全文
