Skip to Content
Advanced MySQL 8
book

Advanced MySQL 8

by Eric Vanier, Birju Shah, Tejaswi Malepati
January 2019
Intermediate to advanced
286 pages
7h 41m
English
Packt Publishing
Content preview from Advanced MySQL 8

How to use MySQL Shell

You can use the mysqlsh command to initiate MySQL Shell, provided you have configured the environment and path variables on Windows. If not, you can open the command prompt and navigate to the bin directory after the Shell download has been extracted.

MySQL Shell provides two ways for connecting to a MySQL server, one of which includes the use of the X Protocol.

Some of the most important commands that you will use to interact with MySQL Shell are as follows:

Command

Alias

Description

\help

\h or \?

This prints help about Shell

\quit

\q or \exit

Exits MySQL Shell

\js

JavaScript execution mode

\py

Python execution mode

\sql

SQL mode

\connect

Connects to ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

MySQL 8 Cookbook

MySQL 8 Cookbook

Karthik Appigatla
High Performance MySQL, 3rd Edition

High Performance MySQL, 3rd Edition

Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
High Performance MySQL, 2nd Edition

High Performance MySQL, 2nd Edition

Jeremy D. Zawodny, Derek J. Balling, Baron Schwartz, Peter Zaitsev, Arjen Lentz, Vadim Tkachenko

Publisher Resources

ISBN: 9781788834445Other