Mysql数据库_简单终端操作

如何使用终端操作数据库

Mysql:关系型数据库

1.如何登陆数据库服务器

mysql -uroot -p123456

2.如何查询数据库服务器中的所有的数据库

mysql> show databases;

3.如何选中某一个数据库进行操作

mysql> use sushe

–sql查询语句

select * from admin;
select * from admin where Admin_id=1;

4.如何退出数据库服务器

exit;

5.如何在数据库服务器中创建数据库？

create database test;

操作演示:

登录数据库:

C:\Users\l1>mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.7.24-log MySQL Community Server (GPL)

Copyright © 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

查询显示数据库

mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mall |
| mysql |
| performance_schema |
| student |
| sys |
| test |
±-------------------+
7 rows in set (0.00 sec)

创建数据库

mysql> create database test1;
Query OK, 1 row affected (0.00 sec)

操作数据库

mysql> use test1;
Database changed

如何查看某个数据库中所有的数据表?

mysql> show tables;
Empty set (0.00 sec)

创建一个数据表

mysql> create table pet(
-> name varchar(20),
-> owner varchar(20),
-> species varchar(20),
-> sex char(1),
-> birth date,
-> death date);
Query OK, 0 rows affected (0.02 sec)

查看数据表是否创建成功

mysql> show tables;
±----------------+
| Tables_in_test1 |
±----------------+
| pet |
±----------------+
1 row in set (0.00 sec)

查看创建好的数据表的结构

mysql> describe pet;
±--------±------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±--------±------------±-----±----±--------±------+
| name | varchar(20) | YES | | NULL | |
| owner | varchar(20) | YES | | NULL | |
| species | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
| death | date | YES | | NULL | |
±--------±------------±-----±----±--------±------+
6 rows in set (0.00 sec)

查看数据表中的记录

mysql> select * from pet;
Empty set (0.00 sec)

往数据表中添加数据记录

mysql> insert into pet
-> values(‘Puffball’,‘Diane’,‘hamster’,‘f’,‘1999-06-12’,null);
Query OK, 1 row affected (0.00 sec)

mysql> select * from pet;
±---------±------±--------±-----±-----------±------+
| name | owner | species | sex | birth | death |
±---------±------±--------±-----±-----------±------+
| Puffball | Diane | hamster | f | 1999-06-12 | NULL |
±---------±------±--------±-----±-----------±------+
1 row in set (0.00 sec)

insert into pet
values(‘旺财’,‘周星驰’,‘狗’,‘公’,‘2020-01-01’,null);

mysql> insert into pet
-> values(‘wangcai’,‘zhouxingchi’,‘gou’,‘f’,‘2020-05-30’,null);
Query OK, 1 row affected (0.00 sec)
mysql> select * from pet;
±---------±------------±--------±-----±-----------±------+
| name | owner | species | sex | birth | death |
±---------±------------±--------±-----±-----------±------+
| Puffball | Diane | hamster | f | 1999-06-12 | NULL |
| wangcai | zhouxingchi | gou | f | 2020-05-30 | NULL |
±---------±------------±--------±-----±-----------±------+
2 rows in set (0.00 sec)