车前猛跑

mysql8修改非root用户密码

SELECT TABLE_NAME , COLUMN_NAME , COLUMN_TYPE ,IF ( IS_NULLABLE = 'YES', '是', '否' ) ,IF ( COLUMN_KEY = 'PRI', '是', '否' ) , COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_SCHEMA = 'enn_md_order' AN...

切换到mysql库use mysql添加用户//允许指定ip连接create user '用户名'@'localhost' identified by '密码';//允许所有ip连接（%表示所有ip）create user 'demo'@'%' identified by 'demo';授权grant all privileges on 数据库名.表名 to '用户名'@'指定ip...

/** * keyProperty: 表示将select返回值设置到该属性中 * resultType: 返回类型 * before: 是否在insert之前执行 * statement: 自定义子查询 * @param userBase */ @SelectKey(keyProperty = "userBase.id",...

1. 下载Select Version:[5.7.23]Select Operating System:[Source Code]Select OS Version:[Generic Linux(Architecture Independent)]Compressed TAR Archive 5.7.23 49.5M(mysql-5.7.23.tar.gz) M...

 update visitor_special set endTime = case mac when 'a' then now() when 'b' then now() when 'c' then now() end, remain = case mac when 'a' then TIMESTAMPDIFF(Minute, startT...