数据库
YUAYU-
坚决、果断、never give up
展开
-
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
报错:Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.tables.DATA_LENGTH’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_b原创 2020-12-29 09:34:13 · 3573 阅读 · 0 评论 -
Mysql 创建用户,赋予权限,查看权限,删除用户,修改密码
查看用户select host,user from mysql.user;+-----------+---------------+| host | user |+-----------+---------------+| % | root || localhost | mysql.session || localhost | mysql.sys |+-----------+---------------+创建用户原创 2020-12-03 10:24:16 · 506 阅读 · 0 评论 -
MySQL 语句练习 + 答案 + 解析 1-20题
学生表 student# 创建表create table student(sid varchar(6), sname varchar(10), sage datetime, ssex varchar(10));# 插入数据insert into student values('01' , '赵雷' , '1990-01-01' , '男');insert into student values('02' , '钱电' , '1990-12-21' , '男');insert into stud原创 2020-08-11 16:51:07 · 1750 阅读 · 0 评论