Practise Datasets (DM)

The MySQL script that you can use to generate the tables of your database:

MynewDB.sql

The MySQL script that you can use to insert data in your database:

MyDB.sql

The data file that will be used to extract data and to insert them in the database using Python script: File.txt

To connect to your MySQLDB using Python, you need to have MySQLDBMySQL-python-1.2.3.tar

Python script to test if MySQLDB is installed or not Script.py

Python script to retrieve informations from your MySQL db that you have created  Select.py

Python script to retrieve informations from a file Read_from_file.py

Python script to retrieve informations from a file and insert them into your MySQL database Retrieve_from_file_insert_in_DB.py

 

 

Leave a Reply