To Get Started in Windows 10:
1. Click on the Windows icon in the lower left of your screen to do a search
2. Search for mysql and click on MySQL Shell
3. Type into the MySQL shell window that comes up...
NOTE: The text below represents a typical session
Type '\help' or '\?' for help; '\quit' to exit.
MySQL JS > \sql
Switching to SQL mode... Commands end with ;
MySQL SQL > \c
\connect [--mx|--mysqlx|--mc|--mysql]
MySQL SQL > \connect root@localhost:3306
Creating a session to 'root@localhost:3306'
Please provide the password for 'root@localhost:3306': *************
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 17
Server version: 8.0.22 MySQL Community Server - GPL
No default schema selected; type \use to set one.
MySQL localhost:3306 ssl SQL > show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sql_hr |
| sql_inventory |
| sql_invoicing |
| sql_store |
| sys |
| world |
+--------------------+
10 rows in set (0.0009 sec)
MySQL localhost:3306 ssl SQL > use sql_store;
Default schema set to `sql_store`.
Fetching table and column names from `sql_store` for auto-completion... Press ^C to stop.
MySQL localhost:3306 ssl sql_store SQL > show tables;
+---------------------+
| Tables_in_sql_store |
+---------------------+
| customers |
| order_item_notes |
| order_items |
| order_statuses |
| orders |
| products |
| shippers |
+---------------------+
7 rows in set (0.0014 sec)
MySQL localhost:3306 ssl sql_store SQL > describe customers;
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+----------------+
| customer_id | int | NO | PRI | NULL | auto_increment |
| first_name | varchar(50) | NO | | NULL | |
| last_name | varchar(50) | NO | | NULL | |
| birth_date | date | YES | | NULL | |
| phone | varchar(50) | YES | | NULL | |
| address | varchar(50) | NO | | NULL | |
| city | varchar(50) | NO | | NULL | |
| state | char(2) | NO | | NULL | |
| points | int | NO | | 0 | |
+-------------+-------------+------+-----+---------+----------------+
9 rows in set (0.0102 sec)
MySQL localhost:3306 ssl sql_store SQL >
\exit