Instance Two:insert Data to Mysql database

#!/usr/bin/env python#--*--coding:utf-8--*--__author__ = ' Kevin ' import mysqldb as Mdbimport Syscon = Mdb.connect (' Local Host ', ' Root ', ' redhat ', ' Test ') Try: With    con:        cur = con.cursor ()        cur.execute ("CREATE TABLE IF not EXISTS Writers (Id INT PRIMARY KEY auto_increment,name VARCHAR)        cur.execute ("INSERT into writers (Name) VALUES (' Jack London ')        cur.execute ("INSERT into writers (name) VALUES (' Tik Tok ')")        Cur.execute ("INSERT into writers (name) VALUES (' Harry Potter ') "Finally:    if con:        con.close ()

Test:

~ $mysql-uroot-penter Password:welcome to the MySQL monitor.  Commands End With; or \g.your MySQL connection ID is 65Server version:5.6.27 mysql Community Server (GPL) Copyright (c) +, Oracle an d/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.mysql> use test;mysql> show tables;+----------------+| Tables_in_test |+----------------+| Writers        | | user           |+----------------+2 rows in Set (0.00 sec) mysql> SELECT * from writers;+----+--------------+ | Id | Name         |+----+--------------+|  1 | Jack London  | |  2 | Tik Tok      | |  3 | Harry Potter |+----+--------------+3 rows in Set (0.01 sec)

Instance Two:insert Data to Mysql database