数据库MySQL-基本操作（增删改查）

基本常见操作（增删改查）

1.建表
create TABLE pet(
name VARCHAR(20),
owner VARCHAR(20),
specise VARCHAR(20),
sex CHAR(1),
brith DATAE,
death DATE );

2.增加
INSERT
eg: INSERT INTO pet VALUES(‘kk’,‘cc’,‘dog’,‘1’,‘1998-8-2’,null);

3.删除
DELECT
eg: delect from pet where name=‘kk’;

4.修改
UPDATE
eg: update pet set name = ‘kk’ where owner = ‘cc2’;

5.查询
SELECT
eg: select * from pet;