flask_sqlalchemy报错ProgrammingError: (pymysql.err.ProgrammingError)

[weixin_38063619]

主代码 param = json.dumps(request.form)
param = json.loads(param)
table_name = param.pop('name')
column_str = ''
for x in range(len(param)/4):
name = param.get('name%s'%(x))
getunique = param.get('unique%s'%(x))
gettype = param.get('type%s'%(x))
getlen = int(param.get('len%d'%(x)))
column_str += '`%(name)s` %(type)s(%(len)s) DEFAULT NULL %(unique)s,'%({'name':name,'type':gettype,'len':getlen,'unique':getunique})
# SET FOREIGN_KEY_CHECKS=0;
# DROP TABLE IF EXISTS `%(table_name)s`;
# ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
creat_sql = r'''CREATE TABLE `%(table_name)s` (`id` int(11) NOT NULL AUTO_INCREMENT,%(column_str)s PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;'''%({'table_name':table_name,'column_str':column_str})
print(creat_sql)
db.session.execute(creat_sql).fetchall()
db.session.commit() 生成sql SET FOREIGN_KEY_CHECKS=0;DROP TABLE IF EXISTS `test`;CREATE TABLE `test` (`id` int(11) NOT NULL AUTO_INCREMENT,`a` int(16) DEFAULT NULL unique,`b` varchar(32) DEFAULT NULL unique, PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
报错 raise errorclass(errno, errval)
ProgrammingError: (pymysql.err.ProgrammingError) (1064, u"You have an error in y
our SQL syntax; check the manual that corresponds to your MySQL server version f
or the right syntax to use near 'CREATE TABLE `test` (`id` int(11) NOT NULL AUTO
_INCREMENT,`a` int(16) DEFAULT NU' at line 1") [SQL: u'DROP TABLE IF EXISTS `tes
t`;CREATE TABLE `test` (`id` int(11) NOT NULL AUTO_INCREMENT,`a` int(16) DEFAULT
NULL unique,`b` varchar(32) DEFAULT NULL unique, PRIMARY KEY (`id`)) ENGINE=MyI
SAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;'] (Background on this error at: http:
//sqlalche.me/e/f405) 求大神指点、里面的\n\r什么的都去除过了，有帖子说需要pymysql.escape_string()进行转义都试过了无法处理