python的sql操作

需要安装mysql

1. 连接数据库

   conn = MySQLdb.connect(
                   host='127.0.0.1',
                   port=3306,
                   user='root',
                   passwd='1.2.336',
                   db='python',
                   charset='utf8',
               )

2.insert into 的使用

    udate 的使用

    delete的使用 

__author__ = 'kkk'
import MySQLdb
conn = MySQLdb.connect(
                host='127.0.0.1',
                port=3306,
                user='root',
                passwd='1.2.336',
                db='python',
                charset='utf8',
            )
cursor=conn.cursor()
sql_insert="insert into user(userid,username) VALUES (10,'name10')"
sql_update="update user set username='name91'where userid=9"
sql_delete="delete from user where userd<3"
try:
    cursor.execute(sql_delete)
    print cursor.rowcount
    cursor.execute(sql_update)
    print cursor.rowcount
    cursor.execute(sql_insert)
    print cursor.rowcount

    conn.commit()
except Exception as e:
    print e

cursor.close()
conn.close()