找到一切高效的方法和工具。
一些还原语句和展示方式。
数据库的创建&列结构的增删改查
create database if not exists new_School_System;
create table if not exists `college_Student`(
`S_id` int(4) not null auto_increment comment '学号',
`S_name` varchar(50) default null comment '姓名',
`S_age` int(3) default null comment '年龄',
`S_sex` varchar(2) default null comment '性别',
`S_score` int(3) default null comment '分数',
`S_email` varchar(30) default null comment '邮箱',
`S_addres` varchar(50) default null comment '地址',
`S_party` varchar(20) default null comment '党派',
primary key (`S_id`)
);
# 源码
show create table college_Student;
# 展示表
desc college_Student;
# 表的操作界面
select * from college_Student;
# 增
alter table college_Student add column `S_psw` varchar(30) after `S_name`;
# 删(库
drop database if exists `new_School_System`;
# 删(表
drop table if exists college_Student;
# 删(列
alter table college_Student drop `S_party`;
alter table college_Student add column `S_party` varchar(20) after `S_name`;
# 改(变量属性
alter table college_Student modify `S_age` varchar(3);
# 改(变量名字
alter table college_Student change `S_party` `S_dogShit` varchar(20);
# 查
select * from college_Student;