CREATE TABLE using Python in the MySQL Shell — with examples.

Not only are basic SQL CRUD operations supported in MySQL Shell Python mode, but you can also execute DDL commands such as CREATE TABLE. While there is not a specific create_table() method per se, there is a sql() method for this – and other – types of commands that don’t have an individual method such as those for each of the individual CRUD operations. Keep reading to see a simple example use of the sql() method…

Photo by Suhyeon Choi on Unsplash

OS, Software, and DB used:

• OpenSuse Leap 15.1
• MySQL 8.0.19

Self-Promotion:

If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!

MySQL Shell CRUD with Python Series

Visit any of the below posts if you’re interested in learning more about basic SQL CRUD with MySQL Shell in Python mode:

• MySQL Shell CRUD with Python: Create — with examples
• MySQL Shell CRUD with Python: Read — with examples
• MySQL Shell CRUD With Python: Update — with examples
• MySQL Shell CRUD With Python: Delete — with examples