Category Archives: MySQL
Importing XML into a database with Python and SQLAlchemy
Let’s begin by analyzing the XML we want to import into our database, it consists of a book’s ISBN, title, and author. <!– books.xml –> <catalog> <book isbn=”1-880985-26-8″> <title>The Consumer</title> <author>M. Gira</author> </book> <book isbn=”0-679775-43-9″> <title>The Wind-Up Bird Chronicle</title> <author>Haruki … Continue reading
Posted in MySQL, Postgres, Python
Leave a comment
Importing data from a file into a MySQL database
In this example we will focus on the exercise importing existing data into a MySQL database and the various problems you may run into. First, let’s look at the data we wish to import, it is the password file for … Continue reading