KANEKI的博客

因为Mac好久没有关过机，非常的卡，然后我就关了一下机 再打开之后一运行mysql -uroot -p 就报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Navicat Premium也连接不到mysql Can't connect to MySQL s...

参考博客：https://blog.youkuaiyun.com/priestmoon/article/details/8016121 delete 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...

create TRIGGER payslip_insert after insert on payslip for each ROW begin update VIP_card set VIP_card.Remaining = Remaining - new.expenditure where VIP_card.IDnumber = new.IDnumber; end 这是一个触发器的模板 ...

有一个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',...

创建用户： create user '用户名' identified by "为创建的用户设置密码"; 为创建的用户分配操作权限： grant <操作集合> on <操作对象> to '用户名'; 操作集合:[insert,update,delete,all privileges] 操作对象:数据库列表下某个数据库databasei的所有表格-> database...