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.注释
-- 单行注释
/*
多行注释
*/