1、建立資料庫:create datebase mydb01;
2、查詢資料庫:show databases;
3、查詢指定資料庫:show create database mydb01;
4、删除資料庫:drop database mydb01;
5、修改資料庫名稱:alter database mydb01 character set utf8;
2、建立表格;
1、create table student(
id int,
name varchar(10),
borthday date
);
2、檢視所有表:show tables;
3、檢視表結構:desc student;
4、删除表:drop table student;
5、添加字段:alter table student add column product varchar(20);
6、删除字段:alter table student drop column name;
7、修改字段類型:alter table student modify column id varchar(10);
8、修改字段名稱:alter table student change column name pname varchar(30);
9、修改表名稱:alter table student rename to pstudent;
轉載于:https://www.cnblogs.com/hankai2735/p/11181042.html