MySQL Shell 8.0.28 sample

MySQLShell8.0.28Sample.sql

MySQL Shell 8.0.28

Copyright (c) 2016, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Type '\help' or '\?' for help; '\quit' to exit.
 MySQL  JS > \connect thanooj@localhost
Creating a session to 'thanooj@localhost'
Please provide the password for 'thanooj@localhost': ********
Save password for 'thanooj@localhost'? [Y]es/[N]o/Ne[v]er (default No): Y
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 22 (X protocol)
Server version: 8.0.28 MySQL Community Server - GPL
No default schema selected; type \use <schema> to set one.
 MySQL  localhost:33060+ ssl  JS > \sql
Switching to SQL mode... Commands end with ;
 MySQL  localhost:33060+ ssl  SQL > use mydb;
Default schema set to `mydb`.
Fetching table and column names from `mydb` for auto-completion... Press ^C to stop.
 MySQL  localhost:33060+ ssl  mydb  SQL > show tables;
Empty set (0.0015 sec)
 MySQL  localhost:33060+ ssl  mydb  SQL > CREATE TABLE Persons (id int, name varchar(255), city varchar(255));
Query OK, 0 rows affected (0.0968 sec)
 MySQL  localhost:33060+ ssl  mydb  SQL > show tables;
+----------------+
| Tables_in_mydb |
+----------------+
| persons        |
+----------------+
1 row in set (0.0018 sec)
 MySQL  localhost:33060+ ssl  mydb  SQL > INSERT INTO Persons VALUES (1, 'sriram', 'ayodhya');
Query OK, 1 row affected (0.0122 sec)
 MySQL  localhost:33060+ ssl  mydb  SQL > INSERT INTO Persons VALUES (2, 'sita', 'mithila');
Query OK, 1 row affected (0.0080 sec)
 MySQL  localhost:33060+ ssl  mydb  SQL > INSERT INTO Persons VALUES (3, 'lakshman', 'ayodhya');
Query OK, 1 row affected (0.0078 sec)
 MySQL  localhost:33060+ ssl  mydb  SQL > INSERT INTO Persons VALUES (4, 'bharath', 'ayodhya');
Query OK, 1 row affected (0.0076 sec)
 MySQL  localhost:33060+ ssl  mydb  SQL > INSERT INTO Persons VALUES (5, 'shatrughna', 'ayodhya');
Query OK, 1 row affected (0.0060 sec)
 MySQL  localhost:33060+ ssl  mydb  SQL > INSERT INTO Persons VALUES (6, 'hanuma', 'kishkinda');
Query OK, 1 row affected (0.0061 sec)
 MySQL  localhost:33060+ ssl  mydb  SQL > select * from persons;
+----+------------+-----------+
| id | name       | city      |
+----+------------+-----------+
|  1 | sriram     | ayodhya   |
|  2 | sita       | mithila   |
|  3 | lakshman   | ayodhya   |
|  4 | bharath    | ayodhya   |
|  5 | shatrughna | ayodhya   |
|  6 | hanuma     | kishkinda |
+----+------------+-----------+
6 rows in set (0.0007 sec)
 MySQL  localhost:33060+ ssl  mydb  SQL >