## 安裝 Mariadb ``` yum -y install mariadb mariadb-server ``` ## 安裝 MySQLdb 模塊 ``` yum -y install MySQL-python ``` ## 基礎 CRUD ``` #!/usr/bin/env python #-*-coding:utf-8-*- import MySQLdb # 連接數據庫 db = MySQLdb.connect("localhost", "root", "root", charset='utf8' ) # 獲取操作游標 cursor = db.cursor() # 目標數據庫存在則將其刪除 cursor.execute("DROP DATABASE IF EXISTS py_con") # 創建新數據庫 cursor.execute("CREATE DATABASE py_con;") # 連接數據庫 cursor.execute("use py_con;") # 創建數據表 sql_ctb="""CREATE TABLE stu_info( FIRST_NAME CHAR(20) NOT NULL, LAST_NAME CHAR(20), AGE INT, SEX CHAR(1))""" cursor.execute(sql_ctb) # 插入語句 sql_ins = """INSERT INTO stu_info(FIRST_NAME, LAST_NAME, AGE, SEX) VALUES ('Moli', 'Sam', 20, 'M')""" cursor.execute(sql_ins) # 關閉連接 db.close() ``` via:[python操作mysql數據庫](http://www.runoob.com/python/python-mysql.html)