Description
This is a simple application to read data from a text file then save them into a mysql table
Requirement
- Python 3
- sudo apt-get install python3-mysql.connector
MySql Table
CREATE TABLE student(idint(11) NOT NULL AUTO_INCREMENT,namevarchar(45) NOT NULL,address_line_1varchar(99) NOT NULL,address_line_2varchar(99) DEFAULT NULL,postcodevarchar(9) NOT NULL,when_created datetime(6) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1