I’ve been using MySQL 8 on Linux for a couple years but the Linux repository version didn’t install the new MySQL Shell. So, I discovered the new MySQL Shell when I installed MySQL 8 (8.0.21) on Windows to teach my student how to use it to learn SQL commands. I encourage you to read the full MySQL Shell document.
The following is a tutorial to provision a
studentdb database in MySQL. It uses the
MySQL Shell (
mysqlsh) and stages for uploads of
comma-separated values files.
After installing MySQL on the Windows 10 OS, open the Window OS Command Line Interface (CLI) shell by entering the following in the search field at the bottom left:
It launches a CLI interface to the Windows OS. The cmd (command) utility opens the CLI in the following …[Read more]