Python Learning record fourth-database

As long as the use of MYSQLDB, please first install MYSQLDB, Baidu can download!

#coding =utf-8
‘‘‘
@author:
Using Python to manipulate MySQL databases
‘‘‘
Import MySQLdb
#import mysqldb.cursors
Conn=mysqldb.connect (user= ' root ', passwd= ' root ') #connect共三个值, user,passwd,host, can be empty without a password and connected to the local database.
Cur=conn.cursor () #创建游标, using cursors for database operations.
conn.select_db (' Test ') #切换数据库
R=cur.execute ("SELECT * from student") #执行SQL
Cur.execute ("INSERT into student (id,name,age) value (98698, ' SSS ',") ") #执行SQL
Conn.commit () #这是坑啊, change the data must be added, no this will result in modification, insert and other operations after the database is not updated!
Print R
Cur.close () Close cursor
Conn.close () Close the database