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

使用adminer將數(shù)據(jù)庫最常用的增刪改查操作

Original 2019-06-15 11:35:51 248
abstract:1)INSERT INTO `user` (`ID`, `name`, `sex`, `age`, `email`, `password`, `status`, `creat_time`) VALUES (1, '張三', 0, 30, 'aa@126.com', '7c4a8d09ca3762af61e59520943dc26494f8941b&

1)INSERT INTO `user` (`ID`, `name`, `sex`, `age`, `email`, `password`, `status`, `creat_time`) VALUES
 (1, '張三', 0, 30, 'aa@126.com', '7c4a8d09ca3762af61e59520943dc26494f8941b', 0, 1560566223);

2)SELECT  concat_ws(`:` ,`id`,`name`) as `res` FROM WHERE `user`;

3)UPDATE `user` SET name = 'zzz' WHERE id= '1';

4)DELETE FROM `user`WHERE id= '1'; 

Correcting teacher:天蓬老師Correction time:2019-06-15 17:10:03
Teacher's summary:sql命令眾多, 這里只是一個入門, 希望你能舉一反三, 查看手冊, 去掌握更多的命令

Release Notes

Popular Entries