Example of how python uses mysqldb to connect to a database

This article describes how to use pythonmysqldb. The code is as follows:

#-*-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 ()

# Disable
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

Import MySQLdb

2. establish a connection with the database
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.