Instance Two: Insert Data to Mysql database

#!/usr/bin/env python
#--*-- coding:utf-8 --*--
__author__ = ‘Kevin‘

import MySQLdb as mdb
import sys

con = 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 -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 65
Server 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 its
affiliates. Other names may be trademarks of their respective
owners.

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

标签：