MySQL数据库及数据表的创建

1.创建一个名叫 db_classes 的数据库：

创建一个叫 db_classes 的数据库MySQL命令：

 create database db_classes;

运行效果：

创建数据库后查看该数据库基本信息MySQL命令：

show create database db_classes;

运行效果：

其他基础操作： 

drop database db_classes;        删除数据库MySQL命令 

show databases;                        查询所有的数据库命令

alter database db1 character set gbk;                     将数据库的字符集修改为gbk

use db1;                                       切换数据库

select database();                        查看当前使用的数据库

2.数据表的创建 ：

mysql> use db_classes;
Database changed
mysql> show tables;
Empty set (0.01 sec)
 
mysql> create table db_hero(
    -> id int not null,
    -> name varchar(100) not null,
    -> world varchar(100),
    -> );
Query OK, 0 rows affected (0.03 sec)
 
mysql> desc db_hero;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| id       | int          | NO   |     | NULL    |       |
| name     | varchar(100) | NO   |     | NULL    |       |
| world    | varchar(100) | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+
9 rows in set (0.00 sec)

3.数据表的插入

mysql> insert into db_hero values(1,"孙悟空","西游记");
Query OK, 1 row affected (0.01 sec)
 
mysql> insert into db_hero values(2,"林黛玉","红楼梦");
Query OK, 1 row affected (0.01 sec)
 
mysql> insert into db_hero values(3,"宋江","水浒传");
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into db_hero values(4,"关羽","三国演义");
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into db_hero values(5,"白龙马","西游记");
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into db_hero values(6,"猪八戒","西游计");
Query OK, 1 row affected (0.00 sec)