MySql in Spring - Shekharrajak/StackRoute_Files GitHub Wiki

https://spring.io/guides/gs/accessing-data-mysql/

Using docker : https://hub.docker.com/r/mysql/mysql-server/

https://hub.docker.com/_/mysql/

[https://dev.mysql.com/downloads/file/?id=472914](https://dev.mysql.com/downloads/file/?id=472914

sudo mysql -u root -p

Basic commands https://www.wikihow.com/Create-a-Database-in-MySQL

create database test_db


mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test_db            |
+--------------------+
5 rows in set (0.47 sec)

mysql> select * from Circle
    -> ;
ERROR 1046 (3D000): No database selected
mysql> use test_db
Database changed
mysql> select * from Circle
    -> ;
ERROR 1146 (42S02): Table 'test_db.Circle' doesn't exist
mysql> create table Circle (id int ,  name varchar(20));
Query OK, 0 rows affected (2.86 sec)

mysql> select * from Circle;
Empty set (0.05 sec)

mysql> insert into circle values (12, "First circle");
ERROR 1146 (42S02): Table 'test_db.circle' doesn't exist
mysql> insert into Circle values (12, "First circle");
Query OK, 1 row affected (0.13 sec)

mysql> select * from Circle;
+------+--------------+
| id   | name         |
+------+--------------+
|   12 | First circle |
+------+--------------+
1 row in set (0.00 sec)