The most famous ORM in the Python community is SQLAlchemy. Once you know how it works, You may want to use an ORM to avoid writing SQL manually and manipulate your tables as they were Python objects. You will have to look at the documentation. Of course, there are thousand of possibilities and options this is a very basic example. # print all the first cell of all the rows It will letĬur.execute('SELECT * FROM YOUR_TABLE_NAME') Then it is just like using any other package : #!/usr/bin/pythonĭb = nnect(host='localhost', # your host, usually localhost This is not mandatory, But it will prevent me from answering 3 or 4 other questions in this post if something goes wrong. (You can use sudo apt-get install python-mysqldb (for debian based distros), yum install MySQL-python (for rpm-based), or dnf install python-mysql (for modern fedora distro) in command line to download.)įor Mac, you can install MySQLdb using Macport.Īfter installing, Reboot.

Please note MySQLdb only supports Python 2.įor Windows user, you can get an exe of MySQLdb.įor Linux, this is a casual package (python-mysqldb).

The most used package to do so is MySQLdb but it's hard to install it using easy_install. Unlike PHP, Only the SQLite driver is installed by default with Python. You must install a MySQL driver before doing anything. Connecting to MYSQL with Python 2 in three steps

Mysql 10038