Shulou(Shulou.com)06/01 Report--

Establish a database connection

Def create_db_connect (): "" brief info for: create_db_connect establish database link 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

Insert data:

Def insert_to_info (conn): cursor = conn.cursor () sql =''insert into info values (% s)''l = [['liza','mary'], [' dh','lxy']] # must be list cursor.executemany (sql,l) # perform multiple insert data operations conn.commit () # do not perform data conn.close ()

Def insert_into_info (conn): cursor = conn.cursor () sql = 'insert into info values (% s)''l = ('lisa','mary') # must be tuple cursor.execute (sql,l) # insert data operation conn.commit () # do not execute cannot insert data conn.close ()

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.