MySQL数据库表的创建

#展示逻辑库的逻辑空间
show databases;

#创建一个逻辑空间
create database demo;

#删除逻辑空间
drop database demo;

#创建一个数据表
use test;
create table student(
 id int unsigned primary key,
 name varchar(20) not null,
 sex char(1) not null,
 birthday date not null,
 tel char(11) not null,
 remark varchar(200)
)character set = utf8;

#向数据表中插入数据
insert into student values(1,"李四","男","2002-01-05","10086100861",null);

#展示数据表
show tables;

#查看表结构
desc student;

#查看建表的SQL语句
show create table student;

#删除数据表
drop table student;

#向数据表中添加字段
ALTER TABLE student
ADD address VARCHAR(200) NOT NULL,
ADD home_tel CHAR(11) NOT NULL;

#修改字段类型和约束
ALTER TABLE student
MODIFY home_tel VARCHAR(20) NOT NULL;

#修改字段名称
ALTER TABLE student
CHANGE address home_address VARCHAR(200) NOT NULL;

#删除字段
ALTER TABLE student
DROP home_tel,
DROP home_address