创建表，参考代码如下；

import pymysql

test=pymysql.connect('localhost','root','root','test1225')

curs=test.cursor()

curs.execute('drop table if exists xixi')

sql="""

create table `xixi`(`names` varchar(255) default null,

`age` int(3) default null,

`income` decimal(8,2) default 0)

ENGINE=InnoDB DEFAULT charset=utf8;

"""

curs.execute(sql)

test.close()

向表中添加数据；

方式一、

import pymysql

test=pymysql.connect('localhost','root','root','test1225')

curs=test.cursor()

sql="""

insert into `xixi` values('xiaohua',34,888.3)

"""

curs.execute(sql)

test.commit()

test.close()

方式二、#从外部传入参数

import pymysql

test=pymysql.connect('localhost','root','root','test1225')

curs=test.cursor()

names='张的美'

age=18

curs.execute('insert into xixi(names,age) values("%s",%d)'%(names,age))

test.commit()

test.close()

方式三、错误回滚

import pymysql

test=pymysql.connect('localhost','root','root','test1225')

curs=test.cursor()

names='张的美'

age=18

money=888

try:

curs.execute('insert into xixi values("%s",%d,%f)' % (names, age, money))

test.commit()

except:

test.rollback()

print('执行错误，并且已回滚')

test.close()