mysql 文档型数据_MySQL新特性文档型数据库

mongodb在文档型数据库这方面一直做的很好，也发展了很多年，MySQL作为一个比较大众的数据库也慢慢支持了该特性，下面介绍一下MySQL支持文档型数据库的简单操作。

环境：

主机名

IP

系统

软件

master

192.168.91.46

RHEL

MYSQL8.0.17/mysqlsh   Ver 8.0.17

[[email protected] ~]# mysqlsh --mysqlx  -u root  -pkavl7kAkkle! --file /opt/world_x-db/world_x.sql WARNING: Using a password on the command line interface can be insecure.  建立schema

Records: 4079  Duplicates: 0  Warnings: 0

Records: 239  Duplicates: 0  Warnings: 0

Records: 239  Duplicates: 0  Warnings: 0

Records: 984  Duplicates: 0  Warnings: 0

进入库中：

[[email protected] ~]# mysqlsh --mysqlx  -u root  -pkavl7kAkkle! --database world_x

MySQL Shell 8.0.17

Copyright (c) 2016, 2019, 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 ‘\?‘ for help; ‘\quit‘ to exit.

WARNING: Using a password on the command line interface can be insecure.

Creating an X protocol session to [email protected]/world_x‘ Fetching schema names for autocompletion... Press ^C to stop.

Your MySQL connection id is 240126 (X protocol)

Server version: 8.0.17 MySQL Community Server - GPL

Default schema `world_x` accessible through db.

MySQL  localhost:33060+ ssl  world_x  JS >

或者：

[[email protected] ~]# mysqlsh --mysqlx  -u root  -pkavl7kAkkle!

MySQL  localhost:33060+ ssl  JS > \use world_x

Default schema `world_x` accessible through db.

MySQL  localhost:33060+ ssl  world_x  JS >

获取所有的表

MySQL  localhost:33060+ ssl  world_x  JS > db.getCollections()

[

]

查看所有的数据：

MySQL  localhost:33060+ ssl  world_x  JS > db.countryinfo.find().limit(1)

{

"GNP": 828,

"_id": "ABW",

"Name": "Aruba",

"IndepYear": null,

"geography": {

"Region": "Caribbean",

"Continent": "North America",

"SurfaceArea": 193

},

"government": {

"HeadOfState": "Beatrix",

"GovernmentForm": "Nonmetropolitan Territory of The Netherlands"

},

"demographics": {

"Population": 103000,

"LifeExpectancy": 78.4000015258789

}

}

1 document in set (0.0005 sec)

MySQL  localhost:33060+ ssl  world_x  JS >

统计有多少条数据：

MySQL  localhost:33060+ ssl  world_x  JS > db.countryinfo.count()

239

创建一个表：

MySQL  localhost:33060+ ssl  world_x  JS > db.createCollection("student_info");

MySQL  localhost:33060+ ssl  world_x  JS > db.getCollections()

[

,

]

MySQL  localhost:33060+ ssl  world_x  JS > db.student_info.add({name:‘thunder‘,age:27,gender:"man"})

Query OK, 1 item affected (0.0066 sec)

MySQL  localhost:33060+ ssl  world_x  JS > db.student_info.add({aihao:"pingpang",yuyan:"shell"})

Query OK, 1 item affected (0.0076 sec)

MySQL  localhost:33060+ ssl  world_x  JS > db.student_info.find()

{

"_id": "00005da579b70000000000000001",

"age": 27,

"name": "thunder",

"gender": "man"

}

{

"_id": "00005da579b70000000000000002",

"aihao": "pingpang",

"yuyan": "shell"

}

2 documents in set (0.0005 sec)

按照条件查询

MySQL  localhost:33060+ ssl  world_x  JS > db.student_info.find("age=27")

{

"_id": "00005da579b70000000000000001",

"age": 27,

"name": "thunder",

"gender": "man"

}

1 document in set (0.0008 sec)

MySQL  localhost:33060+ ssl  world_x  JS > db.student_info.find("age>27")

Empty set (0.0007 sec)

原文：https://www.cnblogs.com/winter1519/p/11684514.html