Introducing MySQL Shell: Administration Made Easy with Python

© Charles Bell 2019

C. BellIntroducing MySQL Shellhttps://doi.org/10.1007/978-1-4842-5083-9_4

4. Using the Shell with SQL Databases

Charles Bell¹ 

(1)

Warsaw, VA, USA

 

Most people who work with MySQL leverage the relational database capabilities using the Structured Query Language (SQL) interface to interact with their data. As we have seen, MySQL Shell is a very capable client that you can use to work with your data using Structured Query Language (SQL) statements. However, MySQL Shell is also a powerful scripting language editor and execution engine.

In this chapter, we will take a brief look at what SQL databases are and how to work with them in the shell, including a brief overview of using SQL. However, we won’t spend a lot of time there since ...