july_young的博客

kubectl get nskubectl create deployment nginx-db --image=nginx:latest -n kube-public

select clazz,sum(score)from table_agroup by clazz此时要建立复合索引在 clazz 和 socre这两个字段

DROP PROCEDURE IF EXISTS testEndHandle;DELIMITER $$ CREATE PROCEDURE testEndHandle()BEGIN DECLARE s_tablename VARCHAR(100); /*显示表的数据库中的所有表 SELECT table_name FROM information_schema.tables ...

select count(0)from information_schema.tableswhere table_schema = '+ 数据库名称+' and table_name = '表名称';

CONVERT(列名 USING utf8) COLLATE utf8_unicode_ci like concat('%',#{filter,jdbcType=VARCHAR},'%'))

SELECT count(*) TABLES, table_schemaFROM information_schema.TABLES   WHERE table_schema = '__你的数据库名称__'GROUP BY table_schema; 

CREATE TABLE `mygoods` ( `goods_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `cat_id` int(11) NOT NULL DEFAULT '0', `price` tinyint(3) NOT NULL DEFAULT '0', `status` tinyint(3) DEFAU...

set global validate_password_policy=0; 设置密码强度检查等级set global validate_password_length=3; 设置密码最低强度set global validate_password_mixed_case_count=0;  set global validate_password_number_count=3;  ...

① 查看mysql的导出路径：SHOW VARIABLES LIKE '%secure%';没有更改的话windows的路径应该是这个：secure-file-priv="C:/ProgramData/MySQL/MySQL Server 5.7/Uploads"② 更改路径：将原来路径注释,添加：secure-file-priv="F:/export"③ 重启mysql数...

SHOW   VARIABLES   LIKE   'log_bin_trust_function_creators'; SET GLOBAL log_bin_trust_function_creators = 1;//打开修改器DROP   FUNCTION   IF   EXISTS   generate_string;DELIMITER //CREATE   FUNCTION  ...