• 创建数据库

create database students_management;

• 创建表

create table students(id int auto_increment primary key not null, name char(15)); 

操作表中数据

• 增insert into 表名 value ();
  插入一列

insert into students (name) values(“name1”),(“name2”);

插入一行

insert into students value (NULL,”WG”,”女”,”1538488488”);

• 删delete from 表名 where … ;

delete from students where id = 5;
delete from students;

• 改update 表名 set … where …;

update students set tel = “13288097888” where name = “张伟”;
update students set age = 19, name = “张鹏” where tel = “132453453”;

• 查select * from 表名 where … ;

select * from students;
select id, name from students;
//查询名字中带有 "王" 字的所有人信息:
select * from students where name like “%王%”;
insert into students value ();
delete from students where …;
update students set name ww = wg where ..;
select id = 5 from students ;
select * from students where sex = “女”;

创建表后对表的修改

• 添加列

alter table students add birthday after age;
alter table students add address char(60) after age;

• 修改列

修改tel为telphone
alter table students change tel telphone char(8);

• 删除列

alter table students drop birthday;

• 重命名

alter table students rename students_1;

• 删除表

drop table students;