Because all three MySQL modules use the portable SQL database API interface, they are able to use the code in the doQuery() function without any modifications. This example creates a series of Connection objects that opens the same database using different MySQL modules. M圜onnection = nnect( host=hostname, user=username, passwd=password, db=database ) M圜onnection = ( host=hostname, user=username, passwd=password, db=database ) # Simple routine to run a query on a database and print the results:Ĭur.execute( "SELECT fname, lname FROM employee" )įor firstname, lastname in cur.fetchall() : In your own code, replace username with the MySQL database username, password with the database user's password, and dbname with the database name: #!/usr/bin/python The sample code works with Python 2.7 and Python 3.x.
The following sample Python code demonstrates how to do this, as well as just how easy it is to switch between the different SQL package implementations.
To install the pymysql package, type the following command:Īfter you install a MySQL package in the virtual environment, you are ready to work with actual databases. To install the mysql-connector-python package, type the following command: To install the mysqlclient package, type the following command:.Type the command for the package you want to install:
To update pip in the virtual environment, type the following command: If you log out of your SSH session (or deactivate the virtual environment by using the deactivate command), make sure you reactivate the virtual environment before following the steps below and running the sample code. All of the following commands in this procedure assume that you are working within the virtual environment. The command prompt now starts with (sqlenv) to indicate that you are working in a Python virtual environment.