[Tutor] SQL querying

Nitin Madhok nmadhok at g.clemson.edu
Thu Aug 30 19:11:01 EDT 2018


Rafael,

Yes you can absolutely do that. You can use the MySQL connector (https://dev.mysql.com/doc/connector-python/en/connector-python-introduction.html <https://dev.mysql.com/doc/connector-python/en/connector-python-example-connecting.html>) or use one of the following modules:

* MySQLdb (comes from package MySQL-python)
* mysql.connector (comes from package mysql-connector-python)
* pymysql (comes from package PyMySQL)

You can install them by doing:

	pip install <package-name>

For example:

	pip install mysql-connector

--

Thanks,
Nitin Madhok
Clemson University

CONFIDENTIALITY NOTICE
This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain privileged and/or confidential information. If you are not the intended recipient of this e-mail, any dissemination, distribution or copying of this e-mail, and any attachments thereto, is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by e-mail or telephone and permanently delete all copies of this e-mail and any attachments.

> On Aug 30, 2018, at 1:41 PM, Rafael Knuth <rafael.knuth at gmail.com> wrote:
> 
> Can I do SQL querying in Python?
> What packages do I need for that purpose? (specifically for mySQL) Thanks.
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> To unsubscribe or change subscription options:
> https://mail.python.org/mailman/listinfo/tutor



More information about the Tutor mailing list