Python connects to MySQL database for operation

The 1.MYSQLDB module is the interface for the Python link MySQL database, which is not installed by default

[email protected] ~]# Yum install mysql-python-y

2. Create a Python script

[email protected] ~]# cat mysql.py

#!/usr/bin/env python

#-*-Coding:utf-8-*-

Import mysqldb as MySQL #导入MySQLdb模块

Db=mysql.connect (user= ' root ', passwd= ' CentOS ', db= ' test ', host= ' localhost ') #连接数据库

Cursor=db.cursor () #创建游标对象

Sql= ' CREATE TABLE test (ID int,name varchar (8)); ' #创建表

Cursor.execute (SQL) #执行sql语句

Db.close () #关闭连接

3. Execute the script, enter the library to see if the success

[Email protected] ~]# Mysql-uroot-pcentos

mysql> use test;

Database changed

Mysql> Show tables;

+----------------+

| Tables_in_test |

+----------------+

| Test |

+----------------+

1 row in Set (0.00 sec)

mysql> desc test;

+-------+------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------+------------+------+-----+---------+-------+

| ID | Int (11) |     YES | |       NULL | |

| name | varchar (8) |     YES | |       NULL | |

+-------+------------+------+-----+---------+-------+

2 rows in Set (0.00 sec)

Python connects to MySQL database for operation