Skip to content

Latest commit

 

History

History
22 lines (16 loc) · 548 Bytes

README.md

File metadata and controls

22 lines (16 loc) · 548 Bytes
Raw

python3-read-file

Description

This is a simple application to read data from a text file then save them into a mysql table

Requirement

  1. Python 3
  2. 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