Java学习-MySQL-基本命令行操作

1.连接数据库

net start mysql
mysql -uroot -p123456
--注释
update mysql.user set authentication_string=password('123456') where user='root' and Host='localhost'; --修改用户密码
flush privileges; --刷新权限

2.查看所有数据库

show databases; --查看所有数据库
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| school             |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

3.查看数据库中所有的表

use school --输入
Database changed --输出
show tables; --查看数据库中所有的表
+------------------+
| Tables_in_school |
+------------------+
| student          |
+------------------+
1 row in set (0.00 sec)

4.显示数据库中所有表的信息

describe student; --显示数据库中所有表的信息
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id    | int(10)      | NO   | PRI | NULL    |       |
| name  | varchar(100) | NO   |     | NULL    |       |
| age   | int(3)       | NO   |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

5.新建数据库

create database westos;
Query OK, 1 row affected (0.00 sec)

查看数据库

show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| school             |
| sys                |
| westos             |
+--------------------+
6 rows in set (0.00 sec)

use westos;
Database changed
show tables;
Empty set (0.00 sec)

6.退出连接

exit
Bye

7.注释

-- 单行注释
/*
多行注释
*/