pymysql

import pymysql
import random

if __name__ == '__main__':

    #1、连接数据库
    db = pymysql.connect('localhost', 'root', '123456', 'wenda', charset='utf8')
    try:

        #2、创建一个游标
        cursor = db.cursor()

        '''
        sql = 'insert into question(title, content, user_id, created_date, comment_count) values ("xxx", "xxx", 1, now(), 0)'
        cursor.execute(sql)
    
        # 获取逐渐id
        qid = cursor.lastrowid
        
        #提交
        db.commit()
        print qid
        '''

        #3、创建sql语句
        sql = 'select * from question order by id desc limit 2'

        #4、执行
        cursor.execute(sql)
        for each in cursor.fetchall():
            print each


    except Exception, e:
        print e

        #5、回滚
        db.rollback()

        #6、关闭数据库
        db.close()