python 与 MySQL数据库

python 与 MySQL数据库

入门

上代码

#!/usr/bin/env python3

# -*- coding: utf-8 -*-

import MySQLdb

import random

conn = MySQLdb.connect(

host='localhost',

port=3306,

user='root',

passwd='zeratel30000',

db='lhf_db_test_1',

)

cur = conn.cursor()

# 创建数据表

# cur.execute(

#    "CREATE TABLE colleague(id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR(20),class VARCHAR(30),age VARCHAR(10))CHARACTER SET utf8 COLLATE utf8_general_ci")

# 插入一条数据

# cur.execute("INSERT INTO colleague VALUES('2','Tom','3 year 2 class','9')")

# a = 1000

# while a > 0:

#    a -= 1

#    insert = "INSERT INTO colleague VALUES(null,'%s','%s','%s')" % (

#          random.choice(['qwe', 'asd', 'zxc', 'aqz', 'wsx', 'edc']),

#        random.choice(['apple', 'pear', 'peach', 'orange', 'lemon']), random.randint(1, 100))

#    cur.execute(insert)

# 修改查询条件的数据

# executeStr = cur.execute("UPDATE colleague SET class='3 year 1 class' WHERE name = 'Tom'")

executeStr = cur.execute("SELECT * from colleague WHERE name='asd'")

print(executeStr)

i = 0

while i < executeStr:

i += 1

print(cur.fetchone())

# # 删除查询条件的数据

# cur.execute("DELETE FROM colleague WHERE age='9'")

cur.close()

conn.commit()

conn.close()