1 创建数据库
新建数据库db1
选择所有者为sa
2 新建表
目标:
过程:
3 插入新数据insert into 表 value()
先选中数据库db1
否则就要先加一条 use db1
插入一个女生‘雨欣’的信息
插入男生‘肖子云’的信息
4 更新字段 update 表 set 字段
现在的表
让所有人 age加2岁:
5 改变某个值 update set where
把‘肖子云’性别变成女
6 删除某行数据 delete from 表 where
删除id=13的那行
全代码
use db_Test
insert INTO employee
values(13,'雨欣','女',24,null)
-- 显示表
select *
from employee
insert into employee
values(17,'李立','男','26')
select *
from employee
-- employee中age+2
use db_Test
update employee
set age=age+2
select *
from employee
-- 肖一子性别改为女
insert into employee
values(15,'肖一子','男',27,'明日科技')
select *
from employee
use db_Test
update employee
set sex='女'
where name='肖一子'
select *
from employee
-- 删除数据 delete from ...where
delete from employee where id=13
select *
from employee