绝了...玩转MySQL Shell

已于 2022-10-13 21:03:54 修改
阅读量671 收藏
点赞数
分类专栏： 深入mysql的世界 文章标签： mysql oracle 数据库
于 2022-10-13 20:59:18 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u011868279/article/details/127307163
版权

  1.Connecting to MySQL Server with MySQL Shell

[root@MaxwellDBA ~]# 
[root@MaxwellDBA ~]# mysqlsh --host=127.0.0.1 --port=33060 --user=cbuser --schema=cookbook
Please provide the password for 'cbuser@127.0.0.1:33060': ******
Save password for 'cbuser@127.0.0.1:33060'? [Y]es/[N]o/Ne[v]er (default No): y
MySQL Shell 8.0.29

Copyright (c) 2016, 2022, 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 '\?' for help; '\quit' to exit.
Creating a session to 'cbuser@127.0.0.1:33060/cookbook'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 212 (X protocol)
Server version: 8.0.26 Source distribution
Default schema `cookbook` accessible through db.
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > connectionData={
                                          -> "host": "127.0.0.1",
                                          -> "user": "cbuser",
                                          -> "schema": "cookbook"
                                          -> }
                                          -> 
{
    "host": "127.0.0.1", 
    "schema": "cookbook", 
    "user": "cbuser"
}
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > shell.connect(connectionData)
Creating a session to 'cbuser@127.0.0.1/cookbook'
Please provide the password for 'cbuser@127.0.0.1': ******
Save password for 'cbuser@127.0.0.1'? [Y]es/[N]o/Ne[v]er (default No): y
Fetching schema names for autocompletion... Press ^C to stop.
Closing old connection...
Your MySQL connection id is 213 (X protocol)
Server version: 8.0.26 Source distribution
Default schema `cookbook` accessible through db.
<Session:cbuser@127.0.0.1:33060>
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > exit
ReferenceError: exit is not defined
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > quit
ReferenceError: quit is not defined
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > \quit
Bye!
[root@MaxwellDBA ~]# mysqlsh mysqlx://cbuser:cbpass@127.0.1/cookbook
MySQL Shell 8.0.29

Copyright (c) 2016, 2022, 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 '\?' for help; '\quit' to exit.
WARNING: Using a password on the command line interface can be insecure.
Creating an X protocol session to 'cbuser@127.0.1/cookbook'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 214 (X protocol)
Server version: 8.0.26 Source distribution
Default schema `cookbook` accessible through db.
 MySQL  127.0.1:33060+ ssl  cookbook  JS > \quit
Bye!
[root@MaxwellDBA ~]# mysqlsh mysqlx://cbuser@127.0.1/cookbook       
Please provide the password for 'cbuser@127.0.1': ******
Save password for 'cbuser@127.0.1'? [Y]es/[N]o/Ne[v]er (default No): y
MySQL Shell 8.0.29

Copyright (c) 2016, 2022, 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 '\?' for help; '\quit' to exit.
Creating an X protocol session to 'cbuser@127.0.1/cookbook'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 215 (X protocol)
Server version: 8.0.26 Source distribution
Default schema `cookbook` accessible through db.
 MySQL  127.0.1:33060+ ssl  cookbook  JS >

  Selecting the protocol

[root@MaxwellDBA ~]# 
[root@MaxwellDBA ~]# mysqlsh --host=127.0.0.1 --user=cbuser --schema=cookbook --mysqlx
MySQL Shell 8.0.29

Copyright (c) 2016, 2022, 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 '\?' for help; '\quit' to exit.
Creating an X protocol session to 'cbuser@127.0.0.1/cookbook'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 217 (X protocol)
Server version: 8.0.26 Source distribution
Default schema `cookbook` accessible through db.
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > \q
Bye!
[root@MaxwellDBA ~]# mysqlsh --host=127.0.0.1 --user=cbuser --schema=cookbook --mysql
MySQL Shell 8.0.29

Copyright (c) 2016, 2022, 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 '\?' for help; '\quit' to exit.
Creating a Classic session to 'cbuser@127.0.0.1/cookbook'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 218
Server version: 8.0.26 Source distribution
Default schema set to `cookbook`.
 MySQL  127.0.0.1:3306 ssl  cookbook  JS > connectionData={
                                        -> "schema":"mysql","host":"127.0.0.1",
                                        -> "user":"cbuser","schema":"cookbook"
                                        -> }
                                        -> 
{
    "host": "127.0.0.1", 
    "schema": "cookbook", 
    "user": "cbuser"
}
 MySQL  127.0.0.1:3306 ssl  cookbook  JS > \q
Bye!
[root@MaxwellDBA ~]# mysqlsh mysqlx://cbuser:cbpass@127.0.0.1/cookbook
MySQL Shell 8.0.29

Copyright (c) 2016, 2022, 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 '\?' for help; '\quit' to exit.
WARNING: Using a password on the command line interface can be insecure.
Creating an X protocol session to 'cbuser@127.0.0.1/cookbook'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 221 (X protocol)
Server version: 8.0.26 Source distribution
Default schema `cookbook` accessible through db.
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > \q
Bye!
[root@MaxwellDBA ~]# mysqlsh mysql://cbuser:cbpass@127.0.0.1/cookbook
MySQL Shell 8.0.29

Copyright (c) 2016, 2022, 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 '\?' for help; '\quit' to exit.
WARNING: Using a password on the command line interface can be insecure.
Creating a Classic session to 'cbuser@127.0.0.1/cookbook'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 223
Server version: 8.0.26 Source distribution
Default schema set to `cookbook`.
 MySQL  127.0.0.1:3306 ssl  cookbook  JS > 
 MySQL  127.0.0.1:3306 ssl  cookbook  JS > \c mysql://cbuser:cbpass@127.0.0.1/cookbook
Creating a Classic session to 'cbuser@127.0.0.1/cookbook'
Fetching schema names for autocompletion... Press ^C to stop.
Closing old connection...
Your MySQL connection id is 224
Server version: 8.0.26 Source distribution
Default schema set to `cookbook`.
 MySQL  127.0.0.1:3306 ssl  cookbook  JS > \q
Bye!
[root@MaxwellDBA ~]# mysqlsh --host=127.0.0.1 --port=33060 --user=cbuser --schema=cookbook --mx
MySQL Shell 8.0.29

Copyright (c) 2016, 2022, 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 '\?' for help; '\quit' to exit.
Creating an X protocol session to 'cbuser@127.0.0.1:33060/cookbook'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 225 (X protocol)
Server version: 8.0.26 Source distribution
Default schema `cookbook` accessible through db.
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > shell.status()
MySQL Shell version 8.0.29

Connection Id:                225
Default schema:               cookbook
Current schema:               cookbook
Current user:                 cbuser@localhost
SSL:                          Cipher in use: TLS_AES_256_GCM_SHA384 TLSv1.3
Using delimiter:              ;
Server version:               8.0.26 Source distribution
Protocol version:             X protocol
Client library:               8.0.29
Connection:                   127.0.0.1 via TCP/IP
TCP port:                     33060
Server characterset:          utf8mb4
Schema characterset:          utf8mb4
Client characterset:          utf8mb4
Conn. characterset:           utf8mb4
Result characterset:          utf8mb4
Compression:                  Enabled (DEFLATE_STREAM)
Uptime:                       2 days 2 hours 18 min 9.0000 sec


 MySQL  127.0.0.1:33060+ ssl  cookbook  JS >

Selecting SQL,JavaScript, or Python Mode

[root@MaxwellDBA ~]# mysqlsh cbuser:cbpass@127.0.0.1/cookbook --py                               
MySQL Shell 8.0.29

Copyright (c) 2016, 2022, 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 '\?' for help; '\quit' to exit.
WARNING: Using a password on the command line interface can be insecure.
Creating a session to 'cbuser@127.0.0.1/cookbook'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 226 (X protocol)
Server version: 8.0.26 Source distribution
Default schema `cookbook` accessible through db.
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > \js
Switching to JavaScript mode...
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > \py
Switching to Python mode...
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > \sql
Switching to SQL mode... Commands end with ;
Fetching table and column names from `cookbook` for auto-completion... Press ^C to stop.
 MySQL  127.0.0.1:33060+ ssl  cookbook  SQL >

Running SQL Session

[root@MaxwellDBA ~]# 
[root@MaxwellDBA ~]# mysqlsh cbuser:cbpass@127.0.0.1/cookbook --sql
MySQL Shell 8.0.29

Copyright (c) 2016, 2022, 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 '\?' for help; '\quit' to exit.
WARNING: Using a password on the command line interface can be insecure.
Creating a session to 'cbuser@127.0.0.1/cookbook'
Fetching schema names for autocompletion... Press ^C to stop.
Fetching table and column names from `cookbook` for auto-completion... Press ^C to stop.
Your MySQL connection id is 227 (X protocol)
Server version: 8.0.26 Source distribution
Default schema set to `cookbook`.
 MySQL  127.0.0.1:33060+ ssl  cookbook  SQL > delimiter | 
 MySQL  127.0.0.1:33060+ ssl  cookbook  SQL > CREATE PROCEDURE get_client_info()
                                           -> BEGIN
                                           -> SELECT GROUP_CONCAT(ATTR_NAME,'=',ATTR_VALUE)
                                           -> FROM performance_schema.session_account_connect_attrs
                                           -> WHERE ATTR_NAME IN ('_client_name','_client_version');
                                           -> END
                                           -> |
Query OK, 0 rows affected (0.0052 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  SQL > delimiter;
ERROR: DELIMITER must be followed by a 'delimiter' character or string
 MySQL  127.0.0.1:33060+ ssl  cookbook  SQL > delimiter ;
 MySQL  127.0.0.1:33060+ ssl  cookbook  SQL > CALL get_client_info();
+-----------------------------------------------------+
| GROUP_CONCAT(ATTR_NAME,'=',ATTR_VALUE)              |
+-----------------------------------------------------+
| _client_name=libmysqlxclient,_client_version=8.0.29 |
+-----------------------------------------------------+
1 row in set (0.0028 sec)

Query OK, 0 rows affected (0.0028 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  SQL >

Running SQL in JavaScript Mode

Use the \sql command , or use the sql() and runSQL() methods that belong to the Session class.

 MySQL  127.0.0.1:33060+ ssl  cookbook  SQL > \js
Switching to JavaScript mode...
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > \sql SELECT * FROM limbs WHERE arms >=2 ORDER BY arms;
+--------------+------+------+
| thing        | legs | arms |
+--------------+------+------+
| armchair     |    4 |    2 |
| human        |    2 |    2 |
| Peg Leg Pete |    1 |    2 |
| squid        |    0 |   10 |
+--------------+------+------+
4 rows in set (0.0008 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > session.runSql(
                                          -> "SELECT * FROM limbs WHERE arms >=2 ORDER BY arms")
                                          -> 
+--------------+------+------+
| thing        | legs | arms |
+--------------+------+------+
| armchair     |    4 |    2 |
| human        |    2 |    2 |
| Peg Leg Pete |    1 |    2 |
| squid        |    0 |   10 |
+--------------+------+------+
4 rows in set (0.0007 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS >

Running SQL in Python Mode

 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > \sql SELECT * FROM movies;
+----+------+----------------------------+
| id | year | movie                      |
+----+------+----------------------------+
|  1 | 1997 | The Fifth Element          |
|  2 | 1999 | The Phantom Menace         |
|  3 | 2001 | The Fellowship of the Ring |
|  4 | 2005 | Kingdom of Heaven          |
|  5 | 2010 | Red                        |
|  6 | 2011 | Unknown                    |
+----+------+----------------------------+
6 rows in set (0.0007 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.run_sql("SELECT * FROM movies WHERE year < ?",[2000])
+----+------+--------------------+
| id | year | movie              |
+----+------+--------------------+
|  1 | 1997 | The Fifth Element  |
|  2 | 1999 | The Phantom Menace |
+----+------+--------------------+
2 rows in set (0.0007 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py >

Working with Tables in JavaScript Mode

 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > session.getDefaultSchema().getTable('limbs').select()
+--------------+------+------+
| thing        | legs | arms |
+--------------+------+------+
| armchair     |    4 |    2 |
| centipede    |   99 |    0 |
| fish         |    0 |    0 |
| human        |    2 |    2 |
| insect       |    6 |    0 |
| Peg Leg Pete |    1 |    2 |
| phonograph   |    0 |    1 |
| space alien  | NULL | NULL |
| squid        |    0 |   10 |
| table        |    4 |    0 |
| tripod       |    3 |    0 |
+--------------+------+------+
11 rows in set (0.0006 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > session.getDefaultSchema().getTable('limbs').select().where('legs >= :legs').orderBy('legs').bind('legs', 4)
+-----------+------+------+
| thing     | legs | arms |
+-----------+------+------+
| armchair  |    4 |    2 |
| table     |    4 |    0 |
| insect    |    6 |    0 |
| centipede |   99 |    0 |
+-----------+------+------+
4 rows in set (0.0007 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > limbs = session.getDefaultSchema().getTable('limbs')
<Table:limbs>
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > session.startTransaction()
Query OK, 0 rows affected (0.0003 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > limbs.insert('thing','legs','arms').values('cat', 4, 0).values('dog', 2, 2)
Query OK, 2 items affected (0.0009 sec)

Records: 2  Duplicates: 0  Warnings: 0
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > limbs.count()
13
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > limbs.update().set('legs', 4).set('arms', 0).where("thing='dog'")
Query OK, 1 item affected (0.0008 sec)

Rows matched: 1  Changed: 1  Warnings: 0
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > limbs.select().where("thing='dog'")
+-------+------+------+
| thing | legs | arms |
+-------+------+------+
| dog   |    4 |    0 |
+-------+------+------+
1 row in set (0.0008 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > limbs.delete().where("thing='cat'")
Query OK, 1 item affected (0.0009 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > limbs.count()
12
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > session.rollback()
Query OK, 0 rows affected (0.0016 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > limbs.count()
11
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > limbs.select().where("thing='dog' or thing='cat'")
Empty set (0.0008 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS >

Working with Tables in Python Mode

 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.get_schema('cookbook').get_table('movies').select()
+----+------+----------------------------+
| id | year | movie                      |
+----+------+----------------------------+
|  1 | 1997 | The Fifth Element          |
|  2 | 1999 | The Phantom Menace         |
|  3 | 2001 | The Fellowship of the Ring |
|  4 | 2005 | Kingdom of Heaven          |
|  5 | 2010 | Red                        |
|  6 | 2011 | Unknown                    |
+----+------+----------------------------+
6 rows in set (0.0005 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > movies=session.get_schema('cookbook').get_table('movies')
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > movies_actors=session.get_schema('cookbook').get_table('movies_actors')
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.start_transaction()
Query OK, 0 rows affected (0.0003 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > movies.insert('year', 'movie').values(2017, 'Darkest Hour')
Query OK, 1 item affected (0.0009 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > movies_actors.insert().values(1997, 'Darkest Hour', 'Gary Oldman')
Query OK, 1 item affected (0.0008 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.commmit()
Traceback (most recent call last):
  File "<string>", line 1, in <module>
AttributeError: unknown attribute: commmit
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.commit()
Query OK, 0 rows affected (0.0025 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.sql("SELECT * FROM movies JOIN movies_actors USING(movie) WHERE actor = 'Gary Oldman'")
+-------------------+----+------+------+-------------+
| movie             | id | year | year | actor       |
+-------------------+----+------+------+-------------+
| The Fifth Element |  1 | 1997 | 1997 | Gary Oldman |
| Darkest Hour      |  8 | 2017 | 1997 | Gary Oldman |
+-------------------+----+------+------+-------------+
2 rows in set (0.0010 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.start_transaction()
Query OK, 0 rows affected (0.0003 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > movies.update().set('year',2017).where("movie='Darest Hour'")
Query OK, 0 items affected (0.0008 sec)

Rows matched: 0  Changed: 0  Warnings: 0
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > movies_actors.update().set('year',2017).where("movie='Darest Hour'")
Query OK, 0 items affected (0.0008 sec)

Rows matched: 0  Changed: 0  Warnings: 0
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.start_transaction()
Query OK, 0 rows affected (0.0004 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > movies.delete().where("movie='Darkest Hour'")
Query OK, 1 item affected (0.0008 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > movies_actors.delete().where("movie='Darkest Hour'")
Query OK, 1 item affected (0.0008 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.commit()
Query OK, 0 rows affected (0.0026 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py >

Working with Collections in JavaScript Mode

 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > collectionlimbs=session.getCurrentSchema().createCollection('CollectionLimbs')
<Collection:CollectionLimbs>
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > session.getCurrentSchema().dropCollection('collectionLimbs')
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > schema={
                                          ->     "$schema": "http://json-schema.org/draft-07/schema",
                                          ->     "id": "http://example.com/cookbook.json",
                                          ->     "type":"object",
                                          ->     "description":"Table limbs as a collection",
                                          ->     "properties":{
                                          ->         "thing": {"type": "string"},
                                          ->         "legs": {
                                          ->             "anyOf":[{"type": "number"},{"type": "null"}],
                                          ->             "default": 0
                                          ->         },
                                          ->         "arms":{
                                          ->             "anyOf": [{"type": "number"},{"type": "null"}],
                                          ->             "default": 0
                                          ->         },
                                          ->         "required":["thing","legs","arms"]
                                          ->     }
                                          -> 
                                          -> 

 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > collectionLimbs=session.getCurrentSchema().createCollection('collectionLimbs',{"validation": {"level": "strict", "schema": schema}})

Controlling the Output Format

 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > \option resultFormat=tabbed
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > artist=session.getCurrentSchema().getTable('artist')
<Table:artist>
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > artist.select()
a_id    name
1       Da Vinci
2       Monet
4       Renoir
3       Van Gogh
4 rows in set (0.0009 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > shell.options.set('resultFormat','vertical')
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > artist.select()
*************************** 1. row ***************************
a_id: 1
name: Da Vinci
*************************** 2. row ***************************
a_id: 2
name: Monet
*************************** 3. row ***************************
a_id: 4
name: Renoir
*************************** 4. row ***************************
a_id: 3
name: Van Gogh
4 rows in set (0.0006 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > shell.options.set('resultFormat','json')
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > artist.select()
{
    "a_id": 1,
    "name": "Da Vinci"
}
{
    "a_id": 2,
    "name": "Monet"
}
{
    "a_id": 4,
    "name": "Renoir"
}
{
    "a_id": 3,
    "name": "Van Gogh"
}
4 rows in set (0.0006 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > shell.options.set('resultFormat','json/raw')
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > artist.select()
{"a_id":1,"name":"Da Vinci"}
{"a_id":2,"name":"Monet"}
{"a_id":4,"name":"Renoir"}
{"a_id":3,"name":"Van Gogh"}
4 rows in set (0.0006 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > shell.options.set('resultFormat','json/array')
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS > artist.select()
[
{"a_id":1,"name":"Da Vinci"},
{"a_id":2,"name":"Monet"},
{"a_id":4,"name":"Renoir"},
{"a_id":3,"name":"Van Gogh"}
]
4 rows in set (0.0009 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  JS >
DB架构
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
设置mysql的schema_sql-server – 如何将用户DEFAULT_SCHEMA设置为“...
weixin_36257554的博客
02-12 1867
发生这种情况的一种方法是使具有CONTROL SERVER服务器级权限的登录(因此不需要实际的USER以访问数据库),而不是sysadmin固定服务器角色(因为这是隐含的默认模式) (dbo)创建一个对象而不显式指定要放入的模式.Implicit Schema and User CreationIn some cases a user can use a database without havi...
MySQL集群方案
Zhuge_Dan的博客
09-04 4372
MySQL集群方案1 方案介绍1.1 概述1.2 软件包1.3 原理1.4 参考资料2 Innodb Cluster搭建2.1 IP规划2.2 基础配置2.2.1 关闭SELinux2.2.2 关闭防火墙或开放需要的业务端口2.2.3 调整max_open_files2.2.4 重启检查SELinux、firewalld和open files2.2.5 配置其它设备2.3 配置主机名解析2.4 检查python版本2.5 卸载系统自带的MySQL2.6 初始化主节点2.6.1 上传、安装软件包2.6.2 创
索引，用户授权，备份
HYJW01的博客
07-14 1597
索引 高效获取数据的数据结构 B+Tree 1，索引分类普通索引 不应用任何限制条件的索引，该索引可以在任何数据类型中创建。 字段本身的约束条件可以判断其值是否为空或唯一。 创建该类型索引后，用户在查询时，便可以通过索引进行查询。唯一性索引 使用UNIQUE参数可以设置唯一索引。 创建该索引时，索引的值必须唯一，通过唯一索引，用户可以快速定位某条记录 主键是一种特殊唯一索引。全文索引 使用FULLTEXT参数可以...
mysql基础
qq_52943068的博客
04-18 292
1. 数据库的种类 1.1 数据结构模型 数据结构模型主要有： 层次模型 网状结构 关系模型 关系模型： 二维关系：row，column 1.1数据库的种类： 在早期数据库的类型一般分为三种 关系型数据库，非关系型数据库，以及网络式数据库 但是在现在的物联网通常把数据库分为两类：关系型数据库和非关系型数据库 1.2关系型数据库的特点 采用的是二维表结构更加适合开发逻辑 数据存储在磁盘中，相比之下更加的安全 可以使用SQL语句在多个表中做复杂的查询 全部由表构成，文件格
mysql shell命令参数_MySQL Shell 1：介绍与理解
weixin_35131425的博客
02-26 658
简介MySQL Shell 是 MySQL Server 的高级客户端和代码编辑器。除了提供的类似于 MySQL 的 SQL 功能外，MySQL Shell 还提供JavaScript 和 Python 脚本功能，并包括与 MySQL 一起使用的 API。MySQL Shell 包含以下用 JavaScript 和 Python 实现的 API：X DevAPI当 MySQL Shell 使用X协...
MySql.Data.dll8.0类库
11-26
MySQL.Data.dll是MySQL数据库连接器的一个重要组成部分，主要用于C#和其他.NET Framework应用程序与MySQL服务器进行交互。这个8.0版本的类库提供了丰富的API，使开发者能够方便地执行SQL查询、管理数据库对象以及...
Mysql备份.shell文件
03-29
上传到/root目录下　内容密码和数据库名更改成自己的数据库名和密码就能直接使用
MicrobeORM.Mysql.v3.0
01-21
MicrobeORM.Mysql.v3.0MicrobeORM.Mysql.v3.0MicrobeORM.Mysql.v3.0MicrobeORM.Mysql.v3.0MicrobeORM.Mysql.v3.0MicrobeORM.Mysql.v3.0MicrobeORM.Mysql.v3.0MicrobeORM.Mysql.v3.0MicrobeORM.Mysql.v3.0MicrobeORM....
MySql5.7.38版本
最新发布
04-11
MySQL 5.7.38 是 MySQL 数据库管理系统的一个重要版本，它在先前的版本基础...在 Unity 开发中，通过 MySql.Data.dll，开发者可以直接在游戏项目中集成 MySQL 数据库，实现动态数据存储和读取，提升游戏体验和可玩性。
mysql.data.dll
07-24
MySQL数据访问库MySQL.data.dll是用于连接和操作MySQL数据库的关键组件，主要在.NET环境中使用，如Visual Studio（VS）项目。这个DLL文件包含了.NET开发者所需的API，使得他们能够通过C#、VB.NET或其他.NET支持的...
mysql和oracle用户管理_mysql用户管理和权限控制
weixin_36192410的博客
01-19 249
最近朋友问我一些mysql用户的问题，就做了一些测试，记录如下：一：用户的创建(两种方法)：方法一：CREATE USER 'username'@'%' IDENTIFIED BY 'password';方法二：GRANT select ON databasename.tablename TO 'username'@'%' ;二：mysql root用户密码设置以及修改。方法1： 用SET PAS...
解决mysql8.0.18报Segmentation fault错的问题
云深海阔专栏
06-05 5886
报错如下： 显示完下面信息之后，就显示： Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Segmentation fault (core dumped) 解决办法： 1、通过命令locate terminal.c查找到我们的这个文件 [root@loca...
sql笔记之基础增删改查（一）
fanhl的博客
04-27 404
参考：https://blog.csdn.net/bobo553443/article/details/81383194 安装mysql的教程如上链接，接下来是mysql的基本操作。 使用软件：MySQLworkbench 一、创建数据库 方法一：可以使用工具栏上的创建数据库直接创建数据库，如下图： 方法二：使用命令：create database 数据库名称;(注意最后有分号)来创建。注意，此...
SQLyog登录错误解决
青树寒鸦的博客
06-25 538
【2058】SQLyog登录错误解决。
MySQL 02 初体验
云哥的博客
04-19 2923
MySQL 是开源的。 MySQL 支持大型的数据库。可以处理拥有上千万条记录的大型数据库。 MySQL 使用标准的 SQL 数据语言形式。 MySQL 可以运行于多个系统上，并且支持多种语言。这些编程语言包括 C、C++、Python、Java、Perl、PHP、Eiffel、Ruby 和 Tcl 等。 MySQL 支持大型数据库，支持 5000 万条记录的数据仓库，32 位系统表文件最大可支持 4GB，64 位系统支持最大的表文件为8TB。 MySQL 是可以定制的，采用了 GPL 协议，你可以修改源
56： 用户授权 、 完全备份 、 增量备份 、 总结和答疑
weixin_46575696的博客
11-15 666
CASE Top NSD RDBM1 DAY04 案例1： 用户授权 案例2：root密码 案例3：数据备份与恢复 案例4：binlog日志 ...
mysql shell 版本信息_如何检查MySQL版本
weixin_34278722的博客
02-26 746
MySQL(及其替代产品MariaDB)是最受欢迎的开源关系数据库管理系统。 MySQL版本之间存在一些重要差异，因此，在某些情况下，了解服务器上正在运行哪个版本可能很重要。例如，如果要在安装之前安装需要特定MySQL版本的应用程序，则需要找出MySQL服务器的版本。在本文中，我们将向您展示如何检查系统上安装的MySQL或MariaDB服务器的版本。从命令行如果您具有对服务器的SSH访问权限，则有...
在Linux系统中用Docker安装mysql
weixin_56306210的博客
08-01 3747
在Linux系统中用Docker安装mysql
mysql util_新特性解读 | MySQL 8.0 shell util 特性
weixin_42118701的博客
01-27 379
作者：杨涛涛本文介绍 MySQL8.0 shell 子模块 Util 的两个导入特性 importTable/import_table(JS和python 版本的命名差异)、importJson/import_json的使用方法。其中import_table 是通过传统 MySQL 协议来通信，Import_json 是通过 X 插件协议来通信。MySQL 一直以来提供导入文件 SQL 命令 lo...
MySQL my.cnf配置完全指南
"MySQL的my.cnf配置文件详解，涵盖了客户端、MySQL实例、mysqldump、mysql命令行工具以及myisamchk的配置。本文档重点在于理解配置选项的作用，而非性能调优。" 在MySQL数据库系统中，my.cnf配置文件扮演着至关重要...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值