mysql --增删改查

创建表并插入数据

create table st14(
studentno  INT(3) UNSIGNED ZEROFILL PRIMARY KEY,
name VARCHAR(10),
sex VARCHAR(2),
age  int,
hometown VARCHAR(10),
class VARCHAR(10),
card VARCHAR(255),
isdelect INT DEFAULT 0
);

insert into st14 VALUES
('1','王昭君','女',20,'北京','1班','31162100000910018',0),
('2','诸葛亮','男',18,'上海','2班','87235958214647020',0),
('3','刘备','男',24,'南京','3班','98230764940128343',0),
('4','关羽','男',22,'安徽','4班','72898231636783201',0),
('5','张飞','女',19,'河南','3班','12872396253622358',0),
('6','孙尚香','女',18,'河北','1班','32276853291927386',0),
('7','百里玄策','男',20,'山西','2班','69283154237972492',0),
('8','小乔','女',18,'河南','3班','12872396253622359',0),
('9','大乔','女',19,'河南','3班','12872396253622358',0),
('10','孙尚香','女',18,'河北','1班','32276853291927386',0);

 

 delect 删除

删除表4中学号为3的数据

DELETE FROM st14 where studentno='3';

 

 update 更新数据

UPDATE st14 SET card='NULL' WHERE studentno='9';
UPDATE st14 SET sex='男' WHERE studentno='5';
UPDATE st14 SET  name='赵云',sex='男' WHERE studentno='7';

 

update st14 SET  isdelect='1' WHERE studentno='1';
update st14 SET  isdelect='1' WHERE studentno='8';

 

 

select 查询

SELECT * from st14 WHERE isdelect='1';
SELECT * from st14 WHERE isdelect='0';
SELECT * from st14 WHERE sex='女';