MySQL数据库梳理（简版）

本节讲解命令行操作MySQL数据库：

# 登录MySQL数据库：
$ mysql -u[用户名] -p[密码]
如：
$ mysql -uroot -p111111
# 查看已有数据库：
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| appinfodb          |
| mybatis            |
| mysql              |
| newsmanagement     |
| performance_schema |
| sakila             |
| ssm                |
| sys                |
| world              |
+--------------------+
# 指明使用某数据库
mysql> use ssm;
Database changed
# 显示数据表
mysql> show tables;
+---------------+
| Tables_in_ssm |
+---------------+
| t_user        |
+---------------+
# 查看数据表结构
mysql> desc t_user;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| username | varchar(255) | NO   | PRI | NULL    |       |
| password | varchar(255) | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+

# 查看记录
mysql> select * from t_user （where [字段名]=[值]）;
+----------+----------+
| username | password |
+----------+----------+
| jensen   | 521      |
| ryan     | 521      |
| zsh      | 521      |
+----------+----------+
3 rows in set (0.00 sec)
# 插入记录
mysql> INSERT INTO t_user VALUE ('FD','521');
Query OK, 1 row affected (0.01 sec)

mysql> select * from t_user;
+----------+----------+
| username | password |
+----------+----------+
| FD       | 521      |
| jensen   | 521      |
| ryan     | 521      |
| zsh      | 521      |
+----------+----------+
4 rows in set (0.00 sec)

# 创建数据表