Welcome to MLink Developer Q&A Community for programmer and developer-Open, Learning and Share
Ask a Question
Welcome To Ask or Share your Answers For Others

Categories

Python创建相同结构的多个数据库表，表名是循环添加的。

0 votes
355 views
in Technique[技术] by (71.8m points)

Python创建相同结构的多个数据库表，表名是循环添加的。

图片描述

图片描述

tabname是数据库表的名称，通过字符串连接，老是出错。


与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

sql语法错误
估计多了一个点了
sql = '''CREATE TABLE ''' + tabname+''''
注意最后一个是四个点


与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome to MLink Developer Q&A Community for programmer and developer-Open, Learning and Share

Just Browsing Browsing

1.2m questions

2.1m answers

5 comments

56.5k users

Most popular tags

Snow Theme by Q2A Market
Powered by Question2Answer
...