06 Python 3 MySQL Database Access - Excel to MySQL
A practical application. Starts from Excel table. Saves as CSV. Python reads in the csv file and converts it to a multi-list. Imports the pymysql module. Connects to a localhost database. Creates a table called STUDENTS and assigns the column names based on the first row's columns in the multi-list. Then deletes the first row in the list. Converts the list to String made up of the rows and replaces the square brackets with parenthesis. Inserts data into the database. Closes the database. --- There is no one solution for this process, this is just one practical way of converting a limited excel sheet into a MySQL database.
--------- Download the csv file below -----------
https://gist.github.com/drjonesy/d40e...
Watch video 06 Python 3 MySQL Database Access - Excel to MySQL online without registration, duration hours minute second in high quality. This video was added by user Ryan Jones 28 February 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 17,568 once and liked it 187 people.