詳細說明Python如何創(chuàng)建數(shù)據(jù)庫連接及插入數(shù)據(jù)

建立數(shù)據(jù)庫連接

def create_db_connect():  
"""  brief info for: create_db_connect         
建立數(shù)據(jù)庫鏈接          
Args:          Return:          Raise:    
"""    conn = MySQLdb.connect(host = "rm-uf6wz3f7kb8sx983zo.mysql.rds.aliyuncs.com",                             
user = "pv_cms",                             
passwd = "pv_cms@123",                             
port = 3306,                             
charset = "utf8",                             
db = "pv_interaction_bigdata")    
      return conn

插入數(shù)據(jù)：

def insert_to_info(conn):    
cursor = conn.cursor()    
sql = '''insert into info values(%s,%s)'''    
l = [['liza','mary'],['dh','lxy']]＃必須是list    
cursor.executemany(sql,l)＃執(zhí)行多條插入數(shù)據(jù)操作    
conn.commit()# 不執(zhí)行不能插入數(shù)據(jù)    
conn.close()
def insert_into_info(conn):    
cursor = conn.cursor()    s
ql = '''insert into info values(%s,%s)'''    
l = ('lisa','mary')＃必須是tuple    
cursor.execute(sql,l)＃插入數(shù)據(jù)操作    
conn.commit()# 不執(zhí)行不能插入數(shù)據(jù)    
conn.close()

【相關推薦】

1. 免費mysql在線視頻教程

2. MySQL最新手冊教程

3. 布爾教育燕十八mysql入門視頻教程

以上就是詳解Python如何建立數(shù)據(jù)庫連接及插入數(shù)據(jù)的詳細內容，更多請關注php中文網(wǎng)其它相關文章！