Skip to main content

The MySQL Shell

  • Chapter
  • First Online:
Introducing the MySQL 8 Document Store
  • 1069 Accesses

Abstract

One of the largest missing features in the old MySQL client (mysql) was the absence of any form of scripting capability. However, it is possible to use the old client to process a batch of SQL commands and there is limited support in the client for writing stored routines (procedures and functions). For those who wanted to create and use scripts for managing their databases (and server), to date there have been external tool options including the MySQL Workbench and MySQL Utilities but nothing dedicated to incorporating multiple scripting languages.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    However, if you’ve used MySQL Fabric or Utilities , using an URI for a connection will look very familiar.

  2. 2.

    Although you can specify passwords in a URI, it is a poor security practice.

  3. 3.

    No, really. You should read it.

  4. 4.

    Python masters often refer to themselves in this manner. Not to be confused with the Knights who say “Ni!”.— https://en.wikipedia.org/wiki/Knights_who_say_Ni

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Charles Bell

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Bell, C. (2018). The MySQL Shell. In: Introducing the MySQL 8 Document Store. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2725-1_4

Download citation

Publish with us

Policies and ethics