MySQL简单使用

MySQL

数据库

登入数据库

mysql -u root -p

(base) zhengshengxi@zhengshengxideMacBook-Pro ~ % mysql -u root -p             
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 8.1.0 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

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;

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| java221201         |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> 

创建数据库

create database 库名;

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

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| java221201         |
| javaDB             |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
6 rows in set (0.00 sec)

mysql> 

删除数据库

drop database 库名;

mysql> drop database javaDB;
Query OK, 0 rows affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| java221201         |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> 

表

进入数据库

use 库名;

mysql> use java221201
Database changed

查看当前进入的数据库

select database();

mysql> select database();
+------------+
| database() |
+------------+
| java221201 |
+------------+
1 row in set (0.00 sec)

查询当前库下所有表

show tables;

mysql> show tables;
Empty set (0.01 sec)

mysql> 

创建表

create table 表名(
字段1 数据类型(长度),
字段2 数据类型(长度),
...
);

常用数据类型

数据类型	解释
Int	整形
Varchar	字符串
Char	字符串
Double	浮点型
Date	日期
Datetime	日期时间
Timestamp	时间戳

mysql> create table t_stu (
    -> sid int(11),
    -> name varchar(20),
    -> sex char(1),
    -> age int,
    -> brithday date
    -> );
Query OK, 0 rows affected, 1 warning (0.04 sec)

mysql> show tables
    -> ^C
mysql> show tables;
+----------------------+
| Tables_in_java221201 |
+----------------------+
| t_stu                |
+----------------------+
1 row in set (0.00 sec)

mysql> 

本文由博客一文多发平台 OpenWrite 发布！