我用的mysql来完成增删改查

Original 2019-04-09 10:35:19 259
abstract:INSERT INTO `user` (`username`,`sex`,`age`,`email`,`status`) VALUES ('舜','男',16,'s@qq.com',-1);DELETE FROM `user` WHERE `id` = 2;UPDATE `user` SET `email` = 'bh@.qq.com'

原有数据20190409101654.png

INSERT INTO `user` (`username`,`sex`,`age`,`email`,`status`) VALUES ('舜','男',16,'s@qq.com',-1);

添加截图20190409102434.png

DELETE FROM `user` WHERE `id` = 2;

删除截图20190409102802.png

UPDATE `user` SET `email` = 'bh@.qq.com' WHERE `id` = 3;

修改截图20190409103100.png

SELECT * FROM `user` WHERE `id` = '1';

查询截图20190409103317.png

Correcting teacher:天蓬老师Correction time:2019-04-09 10:50:41
Teacher's summary:别看SQL语句那么多, 常用的就是CURD几条而已

Release Notes

Popular Entries