MySQl:一种开源的数据库软件,市场占有率很高,现在属于Oracle公司。
使用:phpStudy
创建数据库:create database mysql
打开某个库:use mysql
创建表:create table students(
id int not null primary key, – primary key表示主键
name varchar(8) ,
sex char(4) ,
age tinyint not null,
)
SQL(增删改查)
增(insert):
insert into students (name, sex, age) values(“孙丽华”, “女”, 21);
查(select)
select 列名称 from 表名称 [查询条件];
如: select name, age from students;
select * from students;
select * from students where age > 21 ;
select * from students where name like “%王%”; --模糊查询
select * from students where id<5 and age>20;
删除( delete)
delete from 表名称 where 删除条件;
如: delete from students; 删除表中的所有数据,
delete from students where id=2; //删除表中,id是2的数据。
delete from students where age<20;
修改( update)
update 表名称 set 列名称=新值 where 更新条件;
如:update students set tel=110 where id=5;
update students set age=age+1;
update students set name=“张伟鹏”, age=19 where tel=“13288097888”;