数据库的表查找改删

选择数据库
use mytest;
create table mytest(
id int primary key auto_increment UNSIGNED
)engine=INNODB;

ALTER TABLE student ENGINE=INNODB;

– 查看数据库当中有哪些表

– 查看表结构
show create table student;

– 查看数据表字段
DESC student;
– 查看数据表的结构
show COLUMNS from student from mytest;
show COLUMNS FROM mytest.student;

– 添加字段
ALTER table student ADD address varchar(100);
ALTER table student add telphone char(11) after name;
alter table student add sex char(1) FIRST;

– 修改字段名称及类型
alter table student CHANGE telphone tel char(11);

– 修改字段的数据类型
ALTER TABLE student MODIFY name VARCHAR(10);

– 删除字段
alter TABLE student DROP sex;

– 更改数据表的名称
ALTER TABLE student RENAME mystudent;
RENAME table mystudent TO student;

– 删除数据表
DROP table IF EXISTS student;