Example Analysis of MySQLdb usage in python

Source: Internet
Author: User
This article mainly introduces the usage of MySQLdb in python. The example analyzes the installation and usage of MySQLdb in Python, including the addition, deletion, modification, query, and garbled processing techniques, for more information about MySQLdb usage in python, see the example in this article. Share it with you for your reference. The specific analysis is as follows:

Download and install MySQLdb

① Linux version

Http://sourceforge.net/projects/mysql-python/ download, installation is to install setuptools first, and then under the download file directory, modify mysite. cfg, specify the local mysql-config file path

② Windows

Find a http://www.technicalbard.com/files/MySQL-python-1.2.2.win32-py2.6.exe online

After installation, import MySQLdb will receive a warning like DeprecationWarning: the sets module is deprecated.

The reason is that 2.6 does not know the sets module, but the set built-in function has been added. Find _ init _ in the MySQLdb folder __. py, comment out from sets import ImmutableSet class DBAPISet (ImmutableSet): Add class DBAPISet (frozenset):; find converters. py comment out from sets import BaseSet, Set. Then, Set the values of rows 45th and 129 to set.

Done.

The following demo is started:

Python code

#-*-Coding: UTF-8-*-# mysqldb import time, MySQLdb # connection conn = MySQLdb. connect (host = "localhost", user = "root", passwd = "", db = "test", charset = "utf8") cursor = conn. cursor () # Write SQL = "insert into user (name, created) values (% s, % s)" param = ("aaa", int (time. time () n = cursor.exe cute (SQL, param) print n # update SQL = "update user set name = % s where id = 3" param = ("bbb ") n = cursor.exe cute (SQL, param) print n # query n = cursor.exe cute ("select * from user") for row in cursor. fetchall (): for r in row: print r # delete SQL = "delete from user where name = % s" param = ("aaa") n = cursor.exe cute (SQL, param) print n cursor. close () # close conn. close ()

The basic usage is as simple as above. For further use, you have not performed any operations. First, you can find some information on the Internet for future reference.

1. Introduce the MySQLdb Library

The Code is as follows:

Import MySQLdb

2. Establish a connection with the database

The Code is as follows:

Conn = MySQLdb. connect (host = "localhost", user = "root", passwd = "sa", db = "mytable", charset = "utf8 ")


The connect method is used to establish a connection with the database, receive several parameters, and return the connection object.

Common parameters include
Host: specifies the Database host name. The local host is used by default.
User: Database login name. The default value is the current user.
Passwd: Password for database login. Empty by default.
Db: name of the database to be used. No default value exists.
Port: the TCP port used by the MySQL service. The default value is 3306.
Charset: Database encoding.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.