mysql -h lt_mysql基础命令

最新推荐文章于 2023-05-06 22:10:43 发布
最新推荐文章于 2023-05-06 22:10:43 发布
阅读量239 收藏
点赞数
文章标签： mysql -h lt
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_35578211/article/details/113904669
版权

常见的关系型数据库管理系统：

MySQL：MySQL，MariaDB，Percona-Server

PostgreSQL：简称为pgsql

Oracle

MSSQL

SQL：Structure Query Language，结构化查询语言

约束：constraint，向数据表提供的数据要遵守的限制

主键约束：一个或多个字段的组合，填入的数据必须能在本表中唯一标识本行。且必须提供数据，不能为空(NOT NULL)。

一个表只能存在一个

惟一键约束：一个或多个字段的组合，填入的数据必须能在本表中唯一标识本行。允许为空(NULL)

一个表可以存在多个

外键约束：一个表中的某字段可填入数据取决于另一个表的主键已有的数据

检查性约束

索引：将表中的一个或多个字段中的数据复制一份另存，并且这些数据需要按特定次序排序存储

关系型数据库的常见组件有：

数据库：database

表：table，由行(row)和列(column)组成

索引：index

视图：view

用户：user

权限：privilege

存储过程：procedure

存储函数：function

触发器：trigger

事件调度器：event scheduler

SQL语句类型：

SQL语句类型对应操作

DDL

CREATE：创建

DROP：删除

ALTER：修改

DML

INSERT：向表中插入数据

DELETE：删除表中数据

UPDATE：更新表中数据

SELECT：查询表中数据

DCL

GRANT：授权

REVOKE：移除授权

mysql安装与配置：

1.安装mariadb的所有服务，设置开机自动启动并查看端口号。

[root@win10 private]# mount /dev/cdrom /mnt/mount:/mnt: WARNING: device write-protected, mounted read-only.

[root@win10~]# yum -y install mariadb*[root@win10~]# systemctl enable --now mariadb

Created symlink/etc/systemd/system/mysql.service →/usr/lib/systemd/system/mariadb.service.

Created symlink/etc/systemd/system/mysqld.service →/usr/lib/systemd/system/mariadb.service.

Created symlink/etc/systemd/system/multi-user.target.wants/mariadb.service →/usr/lib/systemd/system/mariadb.service.

[root@win10~]# ss -antl

State Recv-Q Send-Q Local Address:Port Peer Address:Port

LISTEN0 128 0.0.0.0:22 0.0.0.0:*LISTEN0 80 0.0.0.0:3306 0.0.0.0:*LISTEN0 128 *:80 *:*LISTEN0 128 [::]:22 [::]:*LISTEN0 128 *:443 *:*

//语法：mysql [OPTIONS] [database]//常用的OPTIONS： -uUSERNAME//指定用户名，默认为root -hHOST//指定服务器主机，默认为localhost，推荐使用ip地址 -pPASSWORD//指定用户的密码 -P#//指定数据库监听的端口，这里的#需用实际的端口号代替，如-P3307 -V//查看当前使用的mysql版本 -e//不登录mysql执行sql语句后退出，常用于脚本

2.给数据库的root管理员账户设置密码123，再修改成1234

[root@win10 ~]# mysql -uroot

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection idis 8Server version:10.3.17-MariaDB MariaDB Server

Copyright (c)2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> set password = password('123'); #后面的password是加密

Query OK,0 rows affected (0.000sec)

MariaDB [(none)]>[root@win10~]# mysql -uroot -p

Enter password:

ERROR1045 (28000): Access denied for user 'root'@'localhost' (usingpassword:

NO)

[root@win10~]# mysql -uroot -p

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection idis 10Server version:10.3.17-MariaDB MariaDB Server

Copyright (c)2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]>[root@win10~]# mysql -uroot -p

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection idis 11Server version:10.3.17-MariaDB MariaDB Server

Copyright (c)2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> alter user root@localhost identified by '1234';

Query OK,0 rows affected (0.000sec)

MariaDB [(none)]>quit

Bye

3.安全初始化数据库，更改root密码为12345

[root@win10 ~]# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB

SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!In order to log into MariaDB to secure it, we'll need the current

password for the root user. If you've just installed MariaDB, and

you haven't set the root password yet, the password will be blank,

so you should just press enter here.

Enter current passwordfor root (enter fornone):

OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB

root user without the proper authorisation.

You already have a root passwordset, so you can safely answer 'n'.

Change the root password? [Y/n] y

New password:

Re-enter newpassword:

Password updated successfully!Reloading privilege tables..

... Success!Bydefault, a MariaDB installation has an anonymous user, allowing anyone

to log into MariaDB without having to have a user account createdforthem. Thisis intended only fortesting, and to make the installation

go a bit smoother. You should remove them before moving into a

production environment.

Remove anonymous users? [Y/n] y

... Success!Normally, root should only be allowed to connectfrom 'localhost'. This

ensures that someone cannot guess at the root passwordfromthe network.

Disallow root login remotely? [Y/n] n

... skipping.

Bydefault, MariaDB comes with a database named 'test'that anyone can

access. Thisis also intended only fortesting, and should be removed

before moving into a production environment.

Remove test database and access to it? [Y/n] y-Dropping test database...

... Success!

-Removing privileges on test database...

... Success!Reloading the privilege tables will ensure that all changes made so far

will take effect immediately.

Reload privilege tables now? [Y/n] y

... Success!Cleaning up...

All done! If you've completed all of the above steps, your MariaDB

installation should now be secure.

Thanksfor using MariaDB!

4.用两种方法查看数据库

MariaDB [(none)]>show databases;+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

+--------------------+

3 rows in set (0.000sec)

MariaDB [(none)]>quit

Bye

[root@win10~]# mysql -uroot -p12345 -e 'show databases;'

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

+--------------------+

(DDL)

5.创建数据库school之后再删除

MariaDB [(none)]> create database if not exists school; #(ifnot exists)可以不

加

Query OK,1 row affected (0.000sec)

MariaDB [(none)]>show databases;+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| school |

+--------------------+

4 rows in set (0.000sec)

MariaDB [(none)]> drop database if exists school; #(ifexists)可以不加

Query OK,0 rows affected (0.001sec)

MariaDB [(none)]>show databases;+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

+--------------------+

3 rows in set (0.000 sec)

6.创建数据库school，在其里面创建表student，表里面有id，name，age，使用desc命令查看表 student数据。

MariaDB [(none)]>create database school;

Query OK,1 row affected (0.000sec)

MariaDB [(none)]>use school;

Database changed

MariaDB [school]>show tables;

Emptyset (0.000sec)

MariaDB [school]> create table student(id int not null,name varchar(50) null,age

tinyint);

Query OK,0 rows affected (0.004sec)

MariaDB [school]>show tables;+------------------+

| Tables_in_school |

+------------------+

| student |

+------------------+

1 row in set (0.000sec)

MariaDB [school]>desc student;+-------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+

| id | int(11) | NO | | NULL | |

| name | varchar(50) | YES | | NULL | |

| age | tinyint(4) | YES | | NULL | |

+-------+-------------+------+-----+---------+-------+

3 rows in set (0.001 sec)

7.修改表student，插入班级class，之后再删除age一行，最后删除表student。

MariaDB [school]> alter table student add class varchar(20);

Query OK,0 rows affected (0.001sec)

Records:0 Duplicates: 0 Warnings: 0MariaDB [school]>desc student;+-------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+

| id | int(11) | NO | | NULL | |

| name | varchar(50) | YES | | NULL | |

| age | tinyint(4) | YES | | NULL | |

| class | varchar(20) | YES | | NULL | |

+-------+-------------+------+-----+---------+-------+

4 rows in set (0.001sec)

MariaDB [school]>alter table student drop age;

Query OK,0 rows affected (0.007sec)

Records:0 Duplicates: 0 Warnings: 0MariaDB [school]>desc student;+-------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+

| id | int(11) | NO | | NULL | |

| name | varchar(50) | YES | | NULL | |

| class | varchar(20) | YES | | NULL | |

+-------+-------------+------+-----+---------+-------+

3 rows in set (0.001sec)

MariaDB [school]>drop table student;

Query OK,0 rows affected (0.003sec)

MariaDB [school]>show tables;

Emptyset (0.000 sec)

(DCL)

创建授权grant

权限类型(priv_type)

权限类型代表什么？

ALL

所有权限

SELECT

读取内容的权限

INSERT

插入内容的权限

UPDATE

更新内容的权限

DELETE

删除内容的权限

指定要操作的对象db_name.table_name

表示方式意义

*.*

所有库的所有表

db_name

指定库的所有表

db_name.table_name

指定库的指定表

WITH GRANT OPTION：被授权的用户可将自己的权限副本转赠给其他用户，说白点就是将自己的权限完全复制给另一个用户。不建议使用。

8.授权192.168.44.1(自己的主机)与192.168.44.129登录数据库的所有数据库与所有表，权限为所有权限，用户为root，密码为12345

MariaDB [(none)]> grant all on *.* to 'root'@'192.168.44.1' identified by '12345';

Query OK,0 rows affected (0.000sec)

MariaDB [(none)]> grant all on *.* to 'root'@'192.168.44.129' identified by '12345';

Query OK,0 rows affected (0.000 sec)

944d441f618b65acca3d4fb532e1a835.png

9.查看root用户在的192.168.44.1的权限，并取消root用户的192.168.44.129的授权

MariaDB [(none)]> show grants for 'root'@'192.168.44.1';+-------------------------------------------------------------------------------------------------------------------------+

| Grants for root@192.168.44.1 |

+-------------------------------------------------------------------------------------------------------------------------+

| GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.44.1' IDENTIFIED BY PASSWORD '*00A51F3F48415C7D4E8908980D443C29C69B60C9' |

+-------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.000sec)

MariaDB [(none)]> revoke delete on *.* from 'root'@'192.168.44.129';

Query OK,0 rows affected (0.000sec)

MariaDB [(none)]>flush privileges;

Query OK,0 rows affected (0.000sec)

MariaDB [(none)]> show grants for 'root'@'192.168.44.129';+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Grants for root@192.168.44.129 |

+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| GRANT SELECT, INSERT, UPDATE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, DELETE HISTORY ON *.* TO 'root'@'192.168.44.129' IDENTIFIED BY PASSWORD '*00A51F3F48415C7D4E8908980D443C29C69B60C9' |

+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.000 sec)

(DML)

10.在school数据库中创建表student，在其中先单次插入一条数据，再连续插入五条数据。表student包含id,name,age。

MariaDB [(none)]>use school;

Database changed

MariaDB [school]> create table student(id int not null,name varchar(50),age tinyint);

Query OK,0 rows affected (1.671sec)

MariaDB [school]>show tables;+------------------+

| Tables_in_school |

+------------------+

| student |

+------------------+

1 row in set (0.000sec)

MariaDB [school]>desc student;+-------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+

| id | int(11) | NO | | NULL | |

| name | varchar(50) | YES | | NULL | |

| age | tinyint(4) | YES | | NULL | |

+-------+-------------+------+-----+---------+-------+

3 rows in set (0.194sec)

MariaDB [school]> insert into student values(1,'tom',15);

Query OK,1 row affected (0.001sec)

MariaDB [school]> select * fromstudent;+----+------+------+

| id | name | age |

+----+------+------+

| 1 | tom | 15 |

+----+------+------+

1 row in set (0.000sec)

MariaDB [school]> insert into student values(2,'zhangshan',20),(3,'lisi',18),(4,'wangwu',20),(5,'zhaosan',13),(6,'qianliu',14);

Query OK,5 rows affected (0.001sec)

Records:5 Duplicates: 0 Warnings: 0MariaDB [school]> select * fromstudent;+----+-----------+------+

| id | name | age |

+----+-----------+------+

| 1 | tom | 15 |

| 2 | zhangshan | 20 |

| 3 | lisi | 18 |

| 4 | wangwu | 20 |

| 5 | zhaosan | 13 |

| 6 | qianliu | 14 |

+----+-----------+------+

6 rows in set (0.000 sec)

11.创建表teacher，设置id为主键且自动增长。(只有主键才能设置自动增长)

MariaDB [school]> create table teacher(id int not null primary key auto_increment,name varchar(20) not null,age tinyint,salary float);

Query OK,0 rows affected (0.034sec)

MariaDB [school]>desc teacher;+--------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+--------+-------------+------+-----+---------+----------------+

| id | int(11) | NO | PRI | NULL | auto_increment |

| name | varchar(20) | NO | | NULL | |

| age | tinyint(4) | YES | | NULL | |

| salary | float | YES | | NULL | |

+--------+-------------+------+-----+---------+----------------+

4 rows in set (0.001 sec)

12.往表teacher里插入三条数据，再往表teacher里连续插入多条数据。(需指定插入数据的字段)

MariaDB [school]> insert into teacher values(1,'chengsongling',21,4000);

Query OK,1 row affected (0.001sec)

MariaDB [school]> insert into teacher values(2,'wangming',25,5000.50);

Query OK,1 row affected (0.001sec)

MariaDB [school]> insert into teacher values(3,'taochi',25,8000);

Query OK,1 row affected (0.001sec)

MariaDB [school]> select * fromteacher;+----+---------------+------+--------+

| id | name | age | salary |

+----+---------------+------+--------+

| 1 | chengsongling | 21 | 4000 |

| 2 | wangming | 25 | 5000.5 |

| 3 | taochi | 25 | 8000 |

+----+---------------+------+--------+

3 rows in set (0.000sec)

MariaDB [school]> insert into teacher(name,age,salary) values('meijianbiao',30,9000),('mufeng',23,5000),('fangxinxin',24,10000),('leichen',21,10000),('yuqinhao',50,100000),('tanghaolun',10,10000);

Query OK,6 rows affected (0.001sec)

Records:6 Duplicates: 0 Warnings: 0MariaDB [school]> select * fromteacher;+----+---------------+------+--------+

| id | name | age | salary |

+----+---------------+------+--------+

| 1 | chengsongling | 21 | 4000 |

| 2 | wangming | 25 | 5000.5 |

| 3 | taochi | 25 | 8000 |

| 4 | meijianbiao | 30 | 9000 |

| 5 | mufeng | 23 | 5000 |

| 6 | fangxinxin | 24 | 10000 |

| 7 | leichen | 21 | 10000 |

| 8 | yuqinhao | 50 | 100000 |

| 9 | tanghaolun | 10 | 10000 |

+----+---------------+------+--------+

9 rows in set (0.000 sec)

13.修改表teacher中的数据,先把id为9的那行数据年龄改成35，再把年龄改成30，工资改成50000。

MariaDB [school]> update teacher set age = 35 where id = 9;

Query OK,1 row affected (0.009sec)

Rows matched:1 Changed: 1 Warnings: 0MariaDB [school]> select * fromteacher;+----+---------------+------+--------+

| id | name | age | salary |

+----+---------------+------+--------+

| 1 | chengsongling | 21 | 4000 |

| 2 | wangming | 25 | 5000.5 |

| 3 | taochi | 25 | 8000 |

| 4 | meijianbiao | 30 | 9000 |

| 5 | mufeng | 23 | 5000 |

| 6 | fangxinxin | 24 | 10000 |

| 7 | leichen | 21 | 10000 |

| 8 | yuqinhao | 50 | 100000 |

| 9 | tanghaolun | 35 | 10000 |

+----+---------------+------+--------+

9 rows in set (0.000sec)

MariaDB [school]> update teacher set age = 30,salary = 50000 where id = 9;

Query OK,1 row affected (0.001sec)

Rows matched:1 Changed: 1 Warnings: 0MariaDB [school]> select * fromteacher;+----+---------------+------+--------+

| id | name | age | salary |

+----+---------------+------+--------+

| 1 | chengsongling | 21 | 4000 |

| 2 | wangming | 25 | 5000.5 |

| 3 | taochi | 25 | 8000 |

| 4 | meijianbiao | 30 | 9000 |

| 5 | mufeng | 23 | 5000 |

| 6 | fangxinxin | 24 | 10000 |

| 7 | leichen | 21 | 10000 |

| 8 | yuqinhao | 50 | 100000 |

| 9 | tanghaolun | 30 | 50000 |

+----+---------------+------+--------+

9 rows in set (0.000 sec)

SELECT语句

字段column表示法

表示符代表什么？

*

所有字段

as

字段别名，如col1 AS alias1

当表名很长时用别名代替

条件判断语句WHERE

操作类型常用操作符

操作符

>，=，<=，=，!=

BETWEEN column# AND column#

LIKE：模糊匹配

RLIKE：基于正则表达式进行模式匹配

IS NOT NULL：非空

IS NULL：空

条件逻辑操作

AND

OR

NOT

ORDER BY：排序，默认为升序(ASC)

ORDER BY语句意义

ORDER BY ‘column_name'

根据column_name进行升序排序

ORDER BY 'column_name' DESC

根据column_name进行降序排序

ORDER BY ’column_name' LIMIT 2

根据column_name进行升序排序

并只取前2个结果

ORDER BY ‘column_name' LIMIT 1,2

根据column_name进行升序排序

并且略过第1个结果取后面的2个结果

14.查找teacher表name与salary一项,再给name设置显示的别名为姓名，给salary设置显示的别名为薪资。

MariaDB [school]> select name,salary fromteacher;+---------------+--------+

| name | salary |

+---------------+--------+

| chengsongling | 4000 |

| wangming | 5000.5 |

| taochi | 8000 |

| meijianbiao | 9000 |

| mufeng | 5000 |

| fangxinxin | 10000 |

| leichen | 10000 |

| yuqinhao | 100000 |

| tanghaolun | 50000 |

+---------------+--------+

9 rows in set (0.000sec)

MariaDB [school]> select name as '姓名',salary as '薪资' fromteacher;+---------------+--------+

| 姓名 | 薪资 |

+---------------+--------+

| chengsongling | 4000 |

| wangming | 5000.5 |

| taochi | 8000 |

| meijianbiao | 9000 |

| mufeng | 5000 |

| fangxinxin | 10000 |

| leichen | 10000 |

| yuqinhao | 100000 |

| tanghaolun | 50000 |

+---------------+--------+

9 rows in set (0.000 sec)

15.先查找薪资为50000的数据的姓名，再查找薪资大于8000的所有记录，最后查找年龄再25到30之间的记录。

MariaDB [school]> select name from teacher where salary = 50000;+------------+

| name |

+------------+

| tanghaolun |

+------------+

1 row in set (0.000sec)

MariaDB [school]> select * from teacher where salary > 8000;+----+-------------+------+--------+

| id | name | age | salary |

+----+-------------+------+--------+

| 4 | meijianbiao | 30 | 9000 |

| 6 | fangxinxin | 24 | 10000 |

| 7 | leichen | 21 | 10000 |

| 8 | yuqinhao | 50 | 100000 |

| 9 | tanghaolun | 30 | 50000 |

+----+-------------+------+--------+

5 rows in set (0.000sec)

MariaDB [school]> select * from teacher where age between 25 and 30;+----+-------------+------+--------+

| id | name | age | salary |

+----+-------------+------+--------+

| 2 | wangming | 25 | 5000.5 |

| 3 | taochi | 25 | 8000 |

| 4 | meijianbiao | 30 | 9000 |

| 9 | tanghaolun | 30 | 50000 |

+----+-------------+------+--------+

4 rows in set (0.000 sec)

16.查找表teacher中以c开头的姓名的记录，再查找以ing结尾的姓名的记录，最后再查找以ing结尾或ao结尾的姓名的记录。

MariaDB [school]> select * from teacher where name like 'c%';+----+---------------+------+--------+

| id | name | age | salary |

+----+---------------+------+--------+

| 1 | chengsongling | 21 | 4000 |

+----+---------------+------+--------+

1 row in set (0.000sec)

MariaDB [school]> select * from teacher where name like 'ing%';

Emptyset (0.000sec)

MariaDB [school]> select * from teacher where name like '%ing';+----+---------------+------+--------+

| id | name | age | salary |

+----+---------------+------+--------+

| 1 | chengsongling | 21 | 4000 |

| 2 | wangming | 25 | 5000.5 |

+----+---------------+------+--------+

2 rows in set (0.000sec)

MariaDB [school]> select * from teacher where name like '%ing' or name like '%ao';+----+---------------+------+--------+

| id | name | age | salary |

+----+---------------+------+--------+

| 1 | chengsongling | 21 | 4000 |

| 2 | wangming | 25 | 5000.5 |

| 4 | meijianbiao | 30 | 9000 |

| 8 | yuqinhao | 50 | 100000 |

+----+---------------+------+--------+

4 rows in set (0.000 sec)

17.往表teacher里插入两条数据，再增加一行字段为department，默认为空，再把id为11的数据的department改为空格。

MariaDB [school]> insert teacher(name,age,salary) values('yanchuang',80,null),('chenben',69,0);

Query OK,2 rows affected (0.001sec)

Records:2 Duplicates: 0 Warnings: 0MariaDB [school]> select * fromteacher;+----+---------------+------+--------+

| id | name | age | salary |

+----+---------------+------+--------+

| 1 | chengsongling | 21 | 4000 |

| 2 | wangming | 25 | 5000.5 |

| 3 | taochi | 25 | 8000 |

| 4 | meijianbiao | 30 | 9000 |

| 5 | mufeng | 23 | 5000 |

| 6 | fangxinxin | 24 | 10000 |

| 7 | leichen | 21 | 10000 |

| 8 | yuqinhao | 50 | 100000 |

| 9 | tanghaolun | 30 | 50000 |

| 10 | yanchuang | 80 | NULL |

| 11 | chenben | 69 | 0 |

+----+---------------+------+--------+

11 rows in set (0.000sec)

MariaDB [school]> alter table teacher add department varchar(50) null;

Query OK,0 rows affected (0.002sec)

Records:0 Duplicates: 0 Warnings: 0MariaDB [school]> select * fromteacher;+----+---------------+------+--------+------------+

| id | name | age | salary | department |

+----+---------------+------+--------+------------+

| 1 | chengsongling | 21 | 4000 | NULL |

| 2 | wangming | 25 | 5000.5 | NULL |

| 3 | taochi | 25 | 8000 | NULL |

| 4 | meijianbiao | 30 | 9000 | NULL |

| 5 | mufeng | 23 | 5000 | NULL |

| 6 | fangxinxin | 24 | 10000 | NULL |

| 7 | leichen | 21 | 10000 | NULL |

| 8 | yuqinhao | 50 | 100000 | NULL |

| 9 | tanghaolun | 30 | 50000 | NULL |

| 10 | yanchuang | 80 | NULL | NULL |

| 11 | chenben | 69 | 0 | NULL |

+----+---------------+------+--------+------------+

11 rows in set (0.000sec)

MariaDB [school]> update teacher set department = ' ' where id = 11;

Query OK,1 row affected (0.001sec)

Rows matched:1 Changed: 1 Warnings: 0MariaDB [school]> select * fromteacher;+----+---------------+------+--------+------------+

| id | name | age | salary | department |

+----+---------------+------+--------+------------+

| 1 | chengsongling | 21 | 4000 | NULL |

| 2 | wangming | 25 | 5000.5 | NULL |

| 3 | taochi | 25 | 8000 | NULL |

| 4 | meijianbiao | 30 | 9000 | NULL |

| 5 | mufeng | 23 | 5000 | NULL |

| 6 | fangxinxin | 24 | 10000 | NULL |

| 7 | leichen | 21 | 10000 | NULL |

| 8 | yuqinhao | 50 | 100000 | NULL |

| 9 | tanghaolun | 30 | 50000 | NULL |

| 10 | yanchuang | 80 | NULL | NULL |

| 11 | chenben | 69 | 0 | |

+----+---------------+------+--------+------------+

11 rows in set (0.000 sec)

18.查找表teacher中dapartment数据不为空的数据。(数据中null等于空，空白不等于空)

MariaDB [school]> select * from teacher where department is not null;+----+---------+------+--------+------------+

| id | name | age | salary | department |

+----+---------+------+--------+------------+

| 11 | chenben | 69 | 0 | |

+----+---------+------+--------+------------+

1 row in set (0.000 sec)

19.先在表teacher里按age升序排列，再按salary降序排列。

MariaDB [school]> select * fromteacher order by age;+----+---------------+------+--------+------------+

| id | name | age | salary | department |

+----+---------------+------+--------+------------+

| 1 | chengsongling | 21 | 4000 | NULL |

| 7 | leichen | 21 | 10000 | NULL |

| 5 | mufeng | 23 | 5000 | NULL |

| 6 | fangxinxin | 24 | 10000 | NULL |

| 3 | taochi | 25 | 8000 | NULL |

| 2 | wangming | 25 | 5000.5 | NULL |

| 4 | meijianbiao | 30 | 9000 | NULL |

| 9 | tanghaolun | 30 | 50000 | NULL |

| 8 | yuqinhao | 50 | 100000 | NULL |

| 11 | chenben | 69 | 0 | |

| 10 | yanchuang | 80 | NULL | NULL |

+----+---------------+------+--------+------------+

11 rows in set (0.000sec)

MariaDB [school]> select * fromteacher order by salary desc;+----+---------------+------+--------+------------+

| id | name | age | salary | department |

+----+---------------+------+--------+------------+

| 8 | yuqinhao | 50 | 100000 | NULL |

| 9 | tanghaolun | 30 | 50000 | NULL |

| 6 | fangxinxin | 24 | 10000 | NULL |

| 7 | leichen | 21 | 10000 | NULL |

| 4 | meijianbiao | 30 | 9000 | NULL |

| 3 | taochi | 25 | 8000 | NULL |

| 2 | wangming | 25 | 5000.5 | NULL |

| 5 | mufeng | 23 | 5000 | NULL |

| 1 | chengsongling | 21 | 4000 | NULL |

| 11 | chenben | 69 | 0 | |

| 10 | yanchuang | 80 | NULL | NULL |

+----+---------------+------+--------+------------+

11 rows in set (0.000 sec)

truncate语句

truncate与delete的区别：

语句类型特点

delete

DELETE删除表内容时仅删除内容，但会保留表结构

DELETE语句每次删除一行，并在事务日志中为所删除的每行记录一项

可以通过回滚事务日志恢复数据

非常占用空间

truncate

删除表中所有数据，且无法恢复

表结构、约束和索引等保持不变，新添加的行计数值重置为初始值

执行速度比DELETE快，且使用的系统和事务日志资源少

通过释放存储表数据所用的数据页来删除数据，并且只在事务日志中记录页的释放

对于有外键约束引用的表，不能使用TRUNCATE TABLE删除数据

不能用于加入了索引视图的表

20.先删除表teacher中工资为空的数据，再删除department不为空的数据。最后删除整个表teacher的数据。(使用delete命令删除，表依然会存在，且会保留表结构)

MariaDB [school]> delete from teacher where salary is null;

Query OK,1 row affected (0.001sec)

MariaDB [school]> select * fromteacher;+----+---------------+------+--------+------------+

| id | name | age | salary | department |

+----+---------------+------+--------+------------+

| 1 | chengsongling | 21 | 4000 | NULL |

| 2 | wangming | 25 | 5000.5 | NULL |

| 3 | taochi | 25 | 8000 | NULL |

| 4 | meijianbiao | 30 | 9000 | NULL |

| 5 | mufeng | 23 | 5000 | NULL |

| 6 | fangxinxin | 24 | 10000 | NULL |

| 7 | leichen | 21 | 10000 | NULL |

| 8 | yuqinhao | 50 | 100000 | NULL |

| 9 | tanghaolun | 30 | 50000 | NULL |

| 11 | chenben | 69 | 0 | |

+----+---------------+------+--------+------------+

10 rows in set (0.000sec)

MariaDB [school]> delete from teacher where department is not null;

Query OK,1 row affected (0.001sec)

MariaDB [school]> select * fromteacher;+----+---------------+------+--------+------------+

| id | name | age | salary | department |

+----+---------------+------+--------+------------+

| 1 | chengsongling | 21 | 4000 | NULL |

| 2 | wangming | 25 | 5000.5 | NULL |

| 3 | taochi | 25 | 8000 | NULL |

| 4 | meijianbiao | 30 | 9000 | NULL |

| 5 | mufeng | 23 | 5000 | NULL |

| 6 | fangxinxin | 24 | 10000 | NULL |

| 7 | leichen | 21 | 10000 | NULL |

| 8 | yuqinhao | 50 | 100000 | NULL |

| 9 | tanghaolun | 30 | 50000 | NULL |

+----+---------------+------+--------+------------+

9 rows in set (0.000sec)

MariaDB [school]> delete fromteacher;

Query OK,9 rows affected (0.001sec)

MariaDB [school]> select * fromteacher;

Emptyset (0.000sec)

MariaDB [school]>show tables;+------------------+

| Tables_in_school |

+------------------+

| student |

| teacher |

+------------------+

2 rows in set (0.000 sec)

21.再往teacher表里插入数据，会发现id还在顺延，使用truncate可以彻底删除。之后插入数据会发现id重新开始计数。(使用truncate删除的话数据无法恢复)

MariaDB [school]> insert teacher(name,age,salary) values('tom',20,8000),('jerry',23,6000),('zhangsan',22,9000);

Query OK,3 rows affected (0.002sec)

Records:3 Duplicates: 0 Warnings: 0MariaDB [school]> select * fromteacher;+----+----------+------+--------+------------+

| id | name | age | salary | department |

+----+----------+------+--------+------------+

| 12 | tom | 20 | 8000 | NULL |

| 13 | jerry | 23 | 6000 | NULL |

| 14 | zhangsan | 22 | 9000 | NULL |

+----+----------+------+--------+------------+

3 rows in set (0.000sec)

MariaDB [school]>truncate teacher;

Query OK,0 rows affected (0.005sec)

MariaDB [school]> select * fromteacher;

Emptyset (0.000sec)

MariaDB [school]> insert teacher(name,age,salary) values('tom',20,8000),('jerry',23,6000),('zhangsan',22,9000);

Query OK,3 rows affected (0.001sec)

Records:3 Duplicates: 0 Warnings: 0MariaDB [school]> select * fromteacher;+----+----------+------+--------+------------+

| id | name | age | salary | department |

+----+----------+------+--------+------------+

| 1 | tom | 20 | 8000 | NULL |

| 2 | jerry | 23 | 6000 | NULL |

| 3 | zhangsan | 22 | 9000 | NULL |

+----+----------+------+--------+------------+

3 rows in set (0.000 sec)

作业

1.搭建mysql服务

[root@win10 private]# mount /dev/cdrom /mnt/mount:/mnt: WARNING: device write-protected, mounted read-only.

[root@win10~]# yum -y install mariadb*[root@win10~]# systemctl enable --now mariadb

2.创建一个以你名字为名的数据库，并创建一张表student，该表包含三个字段(id，name，age)，表结构如下：

mysql> desc student;

+-------+--------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-------+--------------+------+-----+---------+----------------+

| id | int(11) | NO | PRI | NULL | auto_increment |

| name | varchar(100) | NO | | NULL | |

| age | tinyint(4) | YES | | NULL | |

+-------+--------------+------+-----+---------+----------------+

3 rows in set (0.01 sec)

MariaDB [(none)]> create database ifnot exists csl;

Query OK,1 row affected (0.000sec)

MariaDB [(none)]>use csl;

Database changed

MariaDB [csl]> create table student(id int(11) not null primary key auto_increment,name varchar(100) not null,age tinyint(4));

Query OK,0 rows affected (0.112sec)

MariaDB [csl]>desc student;+-------+--------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-------+--------------+------+-----+---------+----------------+

| id | int(11) | NO | PRI | NULL | auto_increment |

| name | varchar(100) | NO | | NULL | |

| age | tinyint(4) | YES | | NULL | |

+-------+--------------+------+-----+---------+----------------+

3 rows in set (0.001 sec)

3.查看下该新建的表有无内容(用select语句)

MariaDB [csl]> select * fromstudent;

Emptyset (0.000 sec)

4.往新建的student表中插入数据(用insert语句)，结果应如下所示：

+----+-------------+------+

| id | name | age |

+----+-------------+------+

| 1 | tom | 20 |

| 2 | jerry | 23 |

| 3 | wangqing | 25 |

| 4 | sean | 28 |

| 5 | zhangshan | 26 |

| 6 | zhangshan | 20 |

| 7 | lisi | NULL |

| 8 | chenshuo | 10 |

| 9 | wangwu | 3 |

| 10 | qiuyi | 15 |

| 11 | qiuxiaotian | 20 |

+----+-------------+------+

MariaDB [csl]> insert into student(name,age) values('tom',20),('jerry',23),('wangqing',25),('sean',28),('zhangshan',26),('zhangshan',20),('lisi',null),('chengshuo',10),('wangwu',3),('qiuyi',15),('qiuxiaotian',20);

Query OK,11 rows affected (0.001sec)

Records:11 Duplicates: 0 Warnings: 0MariaDB [csl]> select * fromstudent;+----+-------------+------+

| id | name | age |

+----+-------------+------+

| 1 | tom | 20 |

| 2 | jerry | 23 |

| 3 | wangqing | 25 |

| 4 | sean | 28 |

| 5 | zhangshan | 26 |

| 6 | zhangshan | 20 |

| 7 | lisi | NULL |

| 8 | chengshuo | 10 |

| 9 | wangwu | 3 |

| 10 | qiuyi | 15 |

| 11 | qiuxiaotian | 20 |

+----+-------------+------+

11 rows in set (0.000 sec)

5.修改lisi的年龄为50

MariaDB [csl]> update student set age = 50 where id = 7;

Query OK,1 row affected (0.001sec)

Rows matched:1 Changed: 1 Warnings: 0MariaDB [csl]> select * fromstudent;+----+-------------+------+

| id | name | age |

+----+-------------+------+

| 1 | tom | 20 |

| 2 | jerry | 23 |

| 3 | wangqing | 25 |

| 4 | sean | 28 |

| 5 | zhangshan | 26 |

| 6 | zhangshan | 20 |

| 7 | lisi | 50 |

| 8 | chengshuo | 10 |

| 9 | wangwu | 3 |

| 10 | qiuyi | 15 |

| 11 | qiuxiaotian | 20 |

+----+-------------+------+

11 rows in set (0.000 sec)

6.以age字段降序排序

MariaDB [csl]> select * fromstudent order by age desc;+----+-------------+------+

| id | name | age |

+----+-------------+------+

| 7 | lisi | 50 |

| 4 | sean | 28 |

| 5 | zhangshan | 26 |

| 3 | wangqing | 25 |

| 2 | jerry | 23 |

| 1 | tom | 20 |

| 6 | zhangshan | 20 |

| 11 | qiuxiaotian | 20 |

| 10 | qiuyi | 15 |

| 8 | chengshuo | 10 |

| 9 | wangwu | 3 |

+----+-------------+------+

11 rows in set (0.000 sec)

7.查询student表中年龄最小的3位同学跳过前2位

MariaDB [csl]> select * from student order by age limit 2,3;+----+-------------+------+

| id | name | age |

+----+-------------+------+

| 10 | qiuyi | 15 |

| 1 | tom | 20 |

| 11 | qiuxiaotian | 20 |

+----+-------------+------+

3 rows in set (0.000 sec)

8.查询student表中年龄最大的4位同学

MariaDB [csl]> select * from student order by age desc limit 4;+----+-----------+------+

| id | name | age |

+----+-----------+------+

| 7 | lisi | 50 |

| 4 | sean | 28 |

| 5 | zhangshan | 26 |

| 3 | wangqing | 25 |

+----+-----------+------+

4 rows in set (0.000 sec)

9.查询student表中名字叫zhangshan的记录

MariaDB [csl]> select * from student where name = 'zhangshan';+----+-----------+------+

| id | name | age |

+----+-----------+------+

| 5 | zhangshan | 26 |

| 6 | zhangshan | 20 |

+----+-----------+------+

2 rows in set (0.000 sec)

10.查询student表中名字叫zhangshan且年龄大于20岁的记录

MariaDB [csl]> select * from student where name = 'zhangshan' and age>20;+----+-----------+------+

| id | name | age |

+----+-----------+------+

| 5 | zhangshan | 26 |

+----+-----------+------+

1 row in set (0.000 sec)

11.查询student表中年龄在23到30之间的记录

MariaDB [csl]> select * from student where age between 23 and 30;+----+-----------+------+

| id | name | age |

+----+-----------+------+

| 2 | jerry | 23 |

| 3 | wangqing | 25 |

| 4 | sean | 28 |

| 5 | zhangshan | 26 |

+----+-----------+------+

4 rows in set (0.000 sec)

12.修改wangwu的年龄为100

MariaDB [csl]> update student set age = 100 where id = 9;

Query OK,1 row affected (0.001sec)

Rows matched:1 Changed: 1 Warnings: 0MariaDB [csl]> select * fromstudent;+----+-------------+------+

| id | name | age |

+----+-------------+------+

| 1 | tom | 20 |

| 2 | jerry | 23 |

| 3 | wangqing | 25 |

| 4 | sean | 28 |

| 5 | zhangshan | 26 |

| 6 | zhangshan | 20 |

| 7 | lisi | 50 |

| 8 | chengshuo | 10 |

| 9 | wangwu | 100 |

| 10 | qiuyi | 15 |

| 11 | qiuxiaotian | 20 |

+----+-------------+------+

11 rows in set (0.000 sec)

13.删除student中名字叫zhangshan且年龄小于等于20的记录

ariaDB [csl]> delete from student where name = 'zhangshan' and age<=20;

Query OK,1 row affected (0.001sec)

MariaDB [csl]> select * fromstudent;+----+-------------+------+

| id | name | age |

+----+-------------+------+

| 1 | tom | 20 |

| 2 | jerry | 23 |

| 3 | wangqing | 25 |

| 4 | sean | 28 |

| 5 | zhangshan | 26 |

| 7 | lisi | 50 |

| 8 | chengshuo | 10 |

| 9 | wangwu | 100 |

| 10 | qiuyi | 15 |

| 11 | qiuxiaotian | 20 |

+----+-------------+------+

10 rows in set (0.000 sec)

SecretCity
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
讲解MySQL中&lt;=>操作符的用法
09-10
主要介绍了讲解MySQL中&lt;=>操作符的用法,整理自stackoverflow的相关实际问题,需要的朋友可以参考下
mysql 层删改_MySQL删改查
weixin_28951585的博客
01-19 96
一、在MySQL管理软件中，可以通过SQL语句中的DML语言来实现数据的操作，包括1.使用INSERT实现数据的插入2.UPDATE实现数据的更新3.使用DELETE实现数据的删除二、插入数据 INSERT1. 插入完整数据(顺序插入)语法一：INSERT INTO 表名(字段1,字段2,字段3…字段n) VALUES(值1,值2,值3…值n);语法二：INSERT INTO 表名 VALUES ...
mysql 索引 lt =_MySQL索引相关
weixin_42523260的博客
01-27 196
MySQL索引采用的是B+TREE，多列联合索引是一个有序元组，其中各个元素均为数据表的一列。设一个表有M列，建一个度为n的多列联合索引，深度h = lognM，设一组索引列的大小为s，索引文件的大小可以计算为s*M*(1+M/n+M/n2+M/n3+。。。。)SQLServer索引可以include非索引列，include的最大好处是这些列只需要在叶子节点存在，索引可以有效减小索引文件的大小，同...
mysql 索引 lt =_mysql数据库总结以及优化
weixin_26717681的博客
01-27 167
(本文针对Innodb，如果有些的不对的地方，请在下面留言。。。)Mysql是一种开放源代码的关系型数据库管理系统(RDBMS)，使用最常用的数据库管理语言--结构化查询语言(SQL)进行数据库管理。mysql优化少不了sql优化，通常使用explain来查询执行计划。(本地测试数据，数据很少)假设出现这种情况，最为常见的type类型：system：系统表，少量数据，往往不需要进行磁盘IO；con...
mysql关键字l_MySQlL基本使用
weixin_30959465的博客
01-26 532
MySQL1.数据目录数据库：文件夹表：文件数据2.安装目录配置文件 my.imiSQLStructured Query Language:结构化查询语言。。定义了操作所有关系型数据库的规则。每一种数据库操作的方式存在不一样的地方。称之为方言。通用语法SQL语句单行或者多行书写，以分号结尾。可使用空格和缩进来增强语句的可读性MySQL数据库的SQL语句不区分大小写，关键字建议使用大写单行注释--注...
MySQL-msz.rar_MYSQL_MYSQL 手册_mysql api
09-20
MySQL有瑞典的T.c.X公司负责开发和维护，MySQL的用户手册很单纯，只有一个集中的&lt;MySQL Reference Manual>，但其内容覆盖了MySQL的所有信息，因此该手册是了解和掌握MySQL的绝佳文献。 虽然对MySQL的开发不能...
PHP-MYSQL_Database_Connection
03-29
&lt;?php $link = "mysql:host=localhost;dbname=yt_colores"; $usuario = "root"; $pass = ""; try { $pdo = new PDO($link, $usuario, $pass); //echo "CONECTADO A LA BASE DE DATOS"; /*foreach ($pdo->...
mysql-connector-java-5.1.35.zip
09-18
mysql-connector-java-5.1.35.jar驱动包（设置不了免费下载） 官网现在已经下载不到5.1.35版本了，大家可以通过maven的中央仓库下载 &lt;!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->...
mysql-java8-tomcat8
07-17
tar -xvf mysql-5.7.20-1.el7.x86_64.tar.gz -C /usr/local/ 4\进入到解压缩目录 cd /usr/local/mysql 5\安装MySQL需要的类库包 perl \net-tools yum install perl net-tools -y 6\安装mysql的安装包 --...
mysql-binlog-connector-java:mysql-binlog-connector-java
05-21
mysql-binlog-connector-java MySQL Binary Log连接器。 最初，项目是作为的分支开始的，但最终作为完整的重写而结束。 主要差异/特征： ... &lt; artifactId>mysql-binlog-connector-java&lt;/ artifactI
mysql命令 MySQL服务器的客户端工具
01-20
mysql命令是MySQL数据库服务器的客户端工具，它工作在命令行终端中，完成对远程MySQL数据库服务器的操作。 语法格式:  mysql [参数] [数据库] 常用参数： -h MySQL服务器的ip地址或主机名 -u 连接MySQL服务器的用户名 -e 执行MySQL内部命令 -p 连接MySQL服务器的密码 参考实例 连接本地MySQL服务器，并打开数据库： [root@linuxcool ~]# mysql -h localhost -u root -p linuxcool 连接远程MySQL服务器： [root@linuxcool ~]# mysql -h
mysql 查询时报 Empty set (0.00 sec)
weixin_44191019的博客
10-14 1万+
其实就是提示你实体表为空，说的是你的数据库或表里数据为空，或者查找的信息为空。可以直接在表里看一下数据，并核对一下查询语句。
Empty set (0.00 sec)
热门推荐
huiqinbo的专栏
04-14 2万+
估计很多人在mysql  Command Line Client  doc端都遇到过这样的抛出：Empty set (0.00 sec) 其实就是提示你实体表为空，说的是你的数据库或表里数据为空，你添加上数据就可以了 更多交流，更多了解：QQ 444084929 ...
mysql基本语法DDL语句的总结 (笔记)
m0_67499084的博客
05-11 3288
1.登录 方式1 : dos窗口登录 方式2 : mysql自带的客户端登录 本文使用dos窗口模式登录 步骤: 1.使用win键+R,输入cmd回车打开dos命令框 2.在命令框中输入mysql -uroot -p 3.输入密码 代码: mysql -uroot -p 结果: 2.DDL语句--数据库的操作 1.注释相关: -- :普通注释 当行注释 /* mysql的多行注释*/ #特殊注释 2.查询当前my...
索引操作
m0_70608180的博客
05-06 523
在已有的表上创建（CREATE INDEX）index_name:指定所建立的索引名称，一个表可建多个索引，每个索引名称必须是唯一的tbl_name:指定需要建立索引的表名UNIQUE:指定所创建的索引是唯一性索引col_name:指定要创建索引的列名length:指定使用列的前length个字符创建索引ASC|DESC:升序（ASC），降序（DESC）在stusys数据库中student表的sname列上，创建一个普通索引I_studentSname。
MySQL中间件之ProxySQL(3)：初试读写分离
easydb.net
10-14 235
实现一个简单的读写分离 这里通过一个简单的示例实现ProxySQL的读写分离功能，算是ProxySQL的快速入门。即使是快速入门，需要配置的内容也很多，包括：后端MySQL配置、监控配置、发送SQL语句的用户、SQL语句的路由规则。所以，想要实现一个ProxySQL+MySQL，即使只实现最基本的功能，步骤也是挺多的，不过配置的逻辑都很简单。 实验环境： OS：centos7.8 ProxySQL：2.0.14 MySQL：8.0.20 角色 主机IP 端口 server_id ProxyS
show master status 时没有数据显示
01-12 2万+
环境： 系统：centos 7.0 （64位） yum安装的mysql数据库。 今天做mysql主从时，查看master日志时没有数据显示， mysql> show master status; Empty set (0.00 sec) mysql> 从网上搜了一下说是master数据库没有启动show maste
IDL关系运算符Eq Ne Le Lt Gt Ge含义说明
pengfei195的博客
05-07 994
IDL中的关系运算符包括EQ、NE、GE、GT、LE、LT几个，关系运算符返回的是真“True”或假“False”。 EQ（Equal to） 等运算符，如果运算符两边相同则返回真，否则返回假； IDL> print,2 EQ 2.0 1 IDL> var = [2,3] IDL> print,var eq 2 1 0 NE（Not Equal to） ...
Could not find artifact mysql:mysql-connector-java:pom:runtime in alimaven
最新发布
09-02
报错信息"Could not find artifact mysql:mysql-connector-java:pom:runtime in alimaven"表示在alimaven仓库中找不到mysql:mysql-connector-java:pom:runtime这个依赖。常见的解决方案是在pom.xml文件中添加正确的...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值