Mysql学习笔记#5-增删查改 Mysql的增删查改操作
增
INSERT INTO pet VALUES('Fluffy','Harold','cat','f','1993-02-04',NULL);
删
delete from pet where name='Fluffy';
改
-
update pet set name='汪汪财' where owner='周星驰'
(语法类似英语)
查
select *from pet
INSERT INTO pet VALUES('Fluffy','Harold','cat','f','1993-02-04',NULL);
delete from pet where name='Fluffy';
update pet set name='汪汪财' where owner='周星驰'
(语法类似英语)
select *from pet