亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

我用的mysql來完成增刪改查

原創(chuàng) 2019-04-09 10:35:19 263
摘要: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'

原有數(shù)據(jù)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

批改老師:天蓬老師批改時間:2019-04-09 10:50:41
老師總結(jié):別看SQL語句那么多, 常用的就是CURD幾條而已

發(fā)佈手記

熱門詞條