Cruise的博客

mysql从5.7之后开始，支持json数据格式创建表 create table json_user ( uid int auto_increment, data json, primary key(uid) );插入数据1 insert into json_user values( null, ' { "name":"lison", "age":"18", "address":"enjoy" } ...

​-- 写一下MySQL触发器DELIMITER $$CREATE TRIGGER tr_user_insert AFTER INSERT ON sFOR EACH ROWBEGIN INSERT INTO c(cno,cname,CTEACHER) VALUES(6,6,'王二小');END;$$DELIMITER ;-- 测试一下，c 表会自动添加一条记录 INSERT INTO s(sno,sname) VALUES(8,'王二小的老师');​...