|
import pymysql
conn =pymysql.connect(host='127.0.0.1',user='root',passwd='1234',port=3306)
cur=conn.cursor()
cur.execute('create database if not EXISTS db_links')
cur.execute('use db_links')
cur.execute("create table if not EXISTS table_links(ID bigint(7) not null auto_increment,link_name VARCHAR (150),PRIMARY KEY (ID))")
value_1='hello'
cur.execute("insert into table_links(link_name) VALUES (value_1)")
cur.execute('select * from table_links')
get_rows=cur.fetchall()
for get_row in get_rows:
print(get_row)
cur.close()
conn.close()用字符串变量 value_1 给 VALUES 参数赋值的时候,执行报错:
pymysql.err.InternalError: (1054, "Unknown column 'value_1' in 'field list'")
请大神指导:如何用变量给values 赋值,因为要处理从网上得到大量的字符串需要存入数据库。
|
|