建立数据库

mysql -u root -p

Enter password: ****

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 19

Server version: 5.7.14 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

-------------

create database db_user

->

-> ;

Query OK, 1 row affected (0.00 sec)

------------------

show databases

->

-> ;

+--------------------+

| Database |

+--------------------+

| information_schema |

| db_user |

| mysql |

| performance_schema |

| sys |

+--------------------+

5 rows in set (0.00 sec)

mysql> use db_user

Database changed

mysql> create table user_info(id int(4),username char(20),password char(20),is_manager int(2));

Query OK, 0 rows affected (0.04 sec)

---------------------------

create table stu_info(id int(4),姓名 char(10),语文 float,数学 float);

今天建设，

数据库成功