增删改查sql数据库

Original 2019-02-17 18:58:08 324
abstract://新增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

Correcting teacher:查无此人Correction time:2019-02-18 09:12:57
Teacher's summary:增删查改是学习编程的基础,要多练习,特别是查询。完成的不错,继续加油。

Release Notes

Popular Entries