创建一个表
with connection.cursor() as cursor:
cursor.execute('drop table if exists artists')
sql = "create table artists(ARTIST_ID varchar(20), ARTIST_NAME varchar(50));"
#sql1 = 'create table emp(name varchar(10),hiredate date,sal decimal(10,2),dept int(2));'
cursor.execute(sql)
cursor.execute('alter table artists default character set utf8;')
cursor.execute('alter table artists change ARTIST_NAME ARTIST_NAME varchar(50) character set utf8;')
connection.commit()
表名
这里的表名artists
插入的列为 ARTIST_ID, ARTIST_NAME
遇到的问题
mysql在插入中文字符时出现错误
解决问题
use databse
show create table $($号为你的表名）#以此来查看你的表的数据格式是什么
alter table artists default character set utf8;#将table的数据格式改为uhf-8
alter table artists change ARTIST_NAME ARTIST_NAME varchar(50) character set utf8;#chane后面将你要该的列名重复两遍，输入此命令后即可在这列输入utf8格式，即可输入中文
