PHP第8课-MySQL增删查改-九期线上班

#查询
SELECT *FROM account WHERE user_id = 1
SELECT *FROM account WHERE user_id = 1 OR user_id = 3
#删除
DELETE FROM account WHERE user_id = 3
#修改
UPDATE account SET email = '222@qq.com' WHERE user_id = 2
#增加
INSERT INTO account SET user_id = 3 ,username = "333", email = '333@qq.com',`password` = '333' 
INSERT INTO account (user_id,username,email,`password`) VALUES (4,'444','444@qq.com','444')

手写代码

2.创建数据表，每张表有10个字段(截图)