1. 查找
select * from stu
select name,age from stu
2. 插入,增加
INSERT into
stu(id,name,age,sex)
VALUES(1004,"赵六",26,"女")
3. 删除
DELETE from stu
where id=1002
4. 修改
UPDATE stu
set name="李一"
WHERE id=1001
1. 查找
select * from stu
select name,age from stu
2. 插入,增加
INSERT into
stu(id,name,age,sex)
VALUES(1004,"赵六",26,"女")
3. 删除
DELETE from stu
where id=1002
4. 修改
UPDATE stu
set name="李一"
WHERE id=1001