MySQL--1 Database and table operations

1. Database Operation

#创建数据库
Create database name Charset=utf8;

#删除数据库
drop database name;

#切换数据库/Use Database
Use database name;

#查看当前选择的数据库
Select Database ();

#查看所有数据库
show databases;

2. Table operation
#查看当前数据库中所有表
Show tables;

#创建表
Auto_increment indicates auto-grow

CREATE TABLE table name (column and type);
Such as:
CREATE TABLE Students (
ID int auto_increment PRIMARY key,
Name varchar (ten) is not NULL,
Birthday datetime,
Gender bit default 1,
Isdelete bit default 0
);
#修改表
ALTER TABLE table name add|change|drop column name type;
Such as:
#增加列
ALTER TABLE students add hometown varchar (a) not null;
#修改列名
ALTER TABLE students change hometown Tel Int (one) not null;
#删除列
ALTER TABLE students DROP TEL;

MySQL--1 Database and table operations