mysql数据库基础知识--一分钟让你数据库入门(sql基础语法篇)

显示数据库语法

语法：show databases；

mysql> show databases;
+----------------------+
| Database             |
+----------------------+
| information_schema   |
| jdbc_xiangyang_liao1 |
| my_jdbc              |
| myfirstdb            |
| mysql                |
| performance_schema   |
| sys                  |
+----------------------+
7 rows in set (0.02 sec)

新建数据库语法

语法：create database 库名；

mysql> create database new_cre;
Query OK, 1 row affected (0.01 sec)

mysql> show databases;
+----------------------+
| Database             |
+----------------------+
| information_schema   |
| jdbc_xiangyang_liao1 |
| my_jdbc              |
| myfirstdb            |
| mysql                |
| new_cre              |
| performance_schema   |
| sys                  |
+----------------------+
8 rows in set (0.00 sec)

使用数据库语法

语法：use 库名；

mysql> use my_jdbc;
Database changed

显示表语法

语法：show tables；

mysql> show tables;
+-------------------+
| Tables_in_my_jdbc |
+-------------------+
| my_jd             |
| my_jdbc           |
| student           |
| ww                |
| www               |
| wwwww             |
+-------------------+
6 rows in set (0.01 sec)

查询表语法

语法：select * from 表名；

mysql> select * from my_jdbc;
+------+----+------+
| name | id | pass |
+------+----+------+
| w    |  1 |  111 |
+------+----+------+
1 row in set (0.01 sec)