#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
Created on Sat May 20 10:39:57 2017

@author: lishaojun
"""

#import mysql.connector as con
import MySQLdb as con
cnx = con.connect(user='root', password='supermap', database='lte', charset='utf8')
cur = cnx.cursor()



#若表存在，則刪除
cur.execute('drop table if exists a')

#創(chuàng)建表
cur.execute('create table a (a int , b int, c int)')

#向表中寫入記錄
for i in range(0, 100):
    cur.execute('insert into a values(1,2,3)')

#查詢
cur.execute('select * from a')

#遍歷結(jié)果
for row in cur:
    print(row)

#關(guān)閉，清空環(huán)境
cur.close()
cnx.close()