sql
SHKata
Go on
展开
-
Mac下运行mysql出错ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock
因为Mac好久没有关过机,非常的卡,然后我就关了一下机再打开之后一运行mysql -uroot -p就报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)Navicat Premium也连接不到mysqlCan't connect to MySQL s...原创 2019-04-16 20:36:41 · 5063 阅读 · 2 评论 -
ERROR 1093 (HY000): You can't specify target table 'C' for update in FROM clause
参考博客:https://blog.csdn.net/priestmoon/article/details/8016121delete from c where aID in (select a.aID from a,b,c where a.aID = c.aID and c.bID = b.bID and a.name = "abc" and b.name != "abc");报错ERR...原创 2019-04-14 01:10:45 · 611 阅读 · 0 评论 -
mysql触发器There is no NEW row in on DELETE trigger
create TRIGGER payslip_insert after inserton payslipfor each ROWbegin update VIP_card set VIP_card.Remaining = Remaining - new.expenditure where VIP_card.IDnumber = new.IDnumber;end这是一个触发器的模板...原创 2019-04-19 10:50:51 · 7974 阅读 · 0 评论 -
Mysql利用触发器TRIGGER的检查约束
有一个student表如下所示:create table student( ID varchar(10) primary key, NAME varchar(20), GENDER varchar(2), check(GENDER in ('F', 'M')),);SID代表学生的学号,NAME表示学生的名字,GENDER是指学生性别check(GENDER in ('F',...原创 2019-05-05 12:51:38 · 1717 阅读 · 0 评论 -
mysql的授权
创建用户:create user '用户名' identified by "为创建的用户设置密码";为创建的用户分配操作权限:grant <操作集合> on <操作对象> to '用户名';操作集合:[insert,update,delete,all privileges]操作对象:数据库列表下某个数据库databasei的所有表格-> database...原创 2019-05-05 15:29:26 · 159 阅读 · 0 评论