From the course: Using SQL with Python

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Challenge

Challenge

From the course: Using SQL with Python

Start my 1-month free trial Buy for my team

Challenge

“

(bright music) - [Instructor] Congratulations! If you've been following along, you now have enough knowledge to write a useful utility. For this challenge, you will copy all the rows of data from a table on a MySQL database to a table on an SQLite database. In your script, you'll need to create connections to both MySQL and SQLite. You'll need to create tables on both systems. Then you'll add rows of data to the table on MySQL. Then you'll copy that data from the MySQL table to the SQLite table. You'll close both the connections, and for bonus points, write another version that copies from SQLite to MySQL. Expect this project to take you about 30 minutes to an hour. Take your time, experiment a lot. Don't worry if you spend a lot of time on this, that's good, it just means you're learning a lot.

Contents