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