- 博客(4)
- 收藏
- 关注
RSS订阅原创 数据库开发技术
select * from dept,employee where exists(select did from employee where age>21);create view view_sales as select first_half+latter_half from salesselect p1.* from employee p1 join employee p2 on p1.did =p2.did where name="王红"；select * from send wher.
2022-04-28 10:30:42
296
2
原创 POS系统开发
i. SQLyog连接MySQL8.0之前需要先修改root的认证方式，否则会出2058的错误 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';ii. 创建函数或触发器前要先修变量的值 SET GLOBAL log_bin_trust_function_creators=1; This function has none of DETERMINISTIC, NO S...
2022-04-28 10:19:40
430
2
原创 数据库管理
i. SQLyog连接MySQL8.0之前需要先修改root的认证方式，否则会出2058的错误 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';ii. 创建函数或触发器前要先修变量的值 SET GLOBAL log_bin_trust_function_creators=1; This function has none of DETERMINISTIC, NO S...
2022-04-28 10:17:54
138
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人