Ai分享| 功能 | 指令 | 备注 |
|---|---|---|
| 登陆mysql(1) | -uroot -p123456 | 明文密码登陆 |
| 登陆mysql(2) | -uroot -p | 隐形密码登陆 |
| 退出mysql | exit | |
| 查看所有存在库 | show databases; | |
| 选择数据库 | use test; | |
| 创建数据库 | create database bjpowernode; | |
| 查看所有表 | show tables; | |
| 查看版本号 | select version(); | |
| 查看使用的数据库 | select database(); | |
| 查看表的结构 | desc dept; |
|
1 2 3 4 5 6 7 8 9 10 11 |
# 查看所有存在库 mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | test | +--------------------+ |
|
1 2 3 4 5 6 7 8 9 10 11 |
#选择数据库 use test; #查看 test 数据库下所有表 mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | dept | | emp | | salgrade | +----------------+ |
|
1 2 3 4 5 6 7 8 9 |
#查看 dept 表结构 mysql> desc dept; +--------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+---------+-------+ | DEPTNO | int(2) | NO | PRI | NULL | | | DNAME | varchar(14) | YES | | NULL | | | LOC | varchar(13) | YES | | NULL | | +--------+-------------+------+-----+---------+-------+ |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
#查看 emp 表结构 mysql> desc emp; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | EMPNO | int(4) | NO | PRI | NULL | | | ENAME | varchar(10) | YES | | NULL | | | JOB | varchar(9) | YES | | NULL | | | MGR | int(4) | YES | | NULL | | | HIREDATE | date | YES | | NULL | | | SAL | double(7,2) | YES | | NULL | | | COMM | double(7,2) | YES | | NULL | | | DEPTNO | int(2) | YES | | NULL | | +----------+-------------+------+-----+---------+-------+ |
|
1 2 3 4 5 6 7 8 9 |
#查看 salgrade 表结构 mysql> desc salgrade; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | GRADE | int(11) | YES | | NULL | | | LOSAL | int(11) | YES | | NULL | | | HISAL | int(11) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ |
