安装库
pip install mysqlclient
#导入包
import MySQLdb
#建立连接
conn =MySQLdb.Connect(
host = '127.0.0.1',
port =3306,
db ='db_9247',
user ="root",
password='root',
charset= 'utf8'
)
建立游标
cursor= conn.cursor()
sql ='insert into t_test1(name,age) values (%s,%s)'
search_sql='select * from t_test1'
try:
#result =cursor.execute(query=sql,args=('张三',18))#单个插入
# 多行插入
# result = cursor.executemany(query=sql, args=(
# ('李四', 15),
# ('王五', 23),
# ('梁六', 78),
# ))
cursor.execute(query=search_sql)
result = cursor.fetchone()
print(result)
#conn.commit()
except Exception as e:
print(e)
conn.rollback()
finally:
if cursor:
cursor.close()
if conn:
conn.close()