访问所有库:show databases
新建库:create database
删除指定库:drop database
使用库:use 库名
显示所有表:show tables
创建表: create table student{
name varchar(10) not null,
Age int not null,
Id primary key auto_increment
};
查看表:desc student;
更换表名:Alter table student rename to stu
添加字段:alter table student add address varchar(50) not null;
更改字段:alter table student change name newname char(20) not null;
删除字段:alter table student drop column age;
插入一条数据:insert into studnet name ‘张三’,’李四’,‘王泽’;
删除一条数据:delete from student where name=’张三’;
修改一条数据:update student set time=100 where age =20;
选择查找:select from student where age=20;