增删改查sql数据库

原创 2019-02-17 18:58:08 832
摘要://新增INSERT `user` VALUES (null,'杨康',0,67,'yk@php.com',sha1(123456),1,1550396653);//修改UPDATE `user` SET `name` = '洪七公' WHERE id = 4//查找SELECT * FROM `user`WHERE id = 4//删除DELETE

//新增

INSERT `user` VALUES (null,'杨康',0,67,'yk@php.com',sha1(123456),1,1550396653);

//修改

UPDATE `user` SET `name` = '洪七公' WHERE id = 4

//查找

SELECT * FROM `user`WHERE id = 4

//删除

DELETE FROM `user` WHERE id = 6

批改老师:查无此人批改时间:2019-02-18 09:12:57
老师总结:增删查改是学习编程的基础,要多练习,特别是查询。完成的不错,继续加油。

发布手记

热门词条