增、删、改、查
Mysql -u root -p 连接数据库
show databases; 查看数据库
create database xxx; 创建xxx数据库
use xxx 使用xxx数据库
create table result(id int(8),name varchar(20),city varchar(20),score int(5));
在数据库student中创建表result
在表resuit中插入5条数据
insert into result(id,name,city,score) values(1,"wang","beijing",75);
insert into result(id,name,city,score) values(3,"li","shanghai",80);
insert into result(id,name,city,score) values(5,"chen","fuzhou",70);
insert into result(id,name,city,score) values(2,"zhou","xian",90);
insert into result(id,name,city,score) values(7,"han","guangzhou",65);
注意:如果数据是字符型(varchar),必须使用单引号或者双引号包裹。
插入成功后,可以使用如下命令查询result表中的全部内容:
Select * from result;
在表result中删除id=3的数据
delete from result where id=3;
修改id=5的数据,将其score设置为60,
update result set score=60 where id=5;
select * from result; 查询表中所有字段
select name,score from result; 查询表中的name和score字段
select score from result where name="chen"; 查询name为chen学生的分数