Demos ➤ MySQL useful commands

---

Create a database named "test"

create database test;

---

Use the database "test"

use test;

---

Create a table named "example"

CREATE TABLE example( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(30), age INT );

---

Insert values in the table "example"

INSERT INTO example (name, age) VALUES('Timmy Mellowman', '23' );

---

Display values from the table "example"

SELECT * FROM example;

---