Instance Two: Insert Data to Mysql database

標籤：

#!/usr/bin/env python#--*-- coding:utf-8 --*--__author__ = ‘Kevin‘import MySQLdb as mdbimport syscon = mdb.connect(‘localhost‘,‘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 (25))")        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) 2000, 2015, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be 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