mysql--(入门语句2~增删改查语句)

#留言
insert into msg 
(id,title,name,content)
values
(1,'初来乍到','张三','刚来能不能当老大？');

//解决字符集问题
默认建表一般是用utf-8,而我们在windows下窗口是GBk的。
因此需要声明集
set names gbk;

insert into msg 
(id,title,name,content)
values

(1,'初来乍到','张三','刚来能不能当老大？');

insert into msg 
(id,title,name,content)
values
(1,'初来乍到','张三','刚来能不能当老大？');

select *from msg;

insert into msg
(id,title,name,content)
values
(1,'又来了','李四','你只能是千年老二');
//改
update msg
set
id=2,
content='偏要当老大'
where
name='李四'
;

select *from msg;

//增

insert into msg
(id,title,name,content)
values
(3,'3标题','刘备','雌雄双剑'),
(4,'4标题','关羽','青龙偃月刀'),
(5,'5标题','张飞','丈八蛇矛');

//删
delete from msg where id=2;

//查
select id,title from msg;

select *from msg where id>2;

select *from msg;//所有行所有列

select name,content//部分行部分列
from msg
where id>2;