Necessary libraries
pip install mysql-connector-python
pip install simple-term-menu
- Create database
CREATE DATABASE prueba;
USE prueba;
- Create table
CREATE TABLE `Usuario` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`age` int(3) DEFAULT NULL,
PRIMARY KEY (`id`)
);
- Insert data
INSERT INTO Usuario (username, email, age)
VALUES('user', 'correo@gmail.com', 18);
- Select
SELECT * FROM Usuario;
SELECT * FROM Usuario WHERE id = 1;