mysql 动态插入_mySQL多行动态插入PYTHON

我的目标是在表中添加多行数据，但是每次我都会出错，我尝试了代码的多个变体，很抱歉之前没有问这个问题，我不知道怎么做，我没有使用太多的堆栈溢出。在The Updated Code is in the end .

错误：Traceback (most recent call last):

File "G:/Python/sqlconnector4.py", line 25, in

entry_table(number)

File "G:/Python/sqlconnector4.py", line 17, in entry_table

c.execute("INSERT INTO T1 (NAME , ADDRESS ) VALUES (thelist.split("'',''"))")

File "C:\Users\tushar\AppData\Local\Programs\Python\Python36-32\lib\site-packages\mysql\connector\cursor.py", line 559, in execute

self._handle_result(self._connection.cmd_query(stmt))

File "C:\Users\tushar\AppData\Local\Programs\Python\Python36-32\lib\site-packages\mysql\connector\connection.py", line 494, in cmd_query

result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))

File "C:\Users\tushar\AppData\Local\Programs\Python\Python36-32\lib\site-packages\mysql\connector\connection.py", line 396, in _handle_result

raise errors.get_exception(packet)

mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

进口mysql.connector在

我的=mysql.connector.connect(host='localhost'，user='root'，password='rootroot'，database='tushar')

c=我的光标()

def create_table()：c.execute("CREATE TABLE IF NOT EXISTS T1 (ID INT AUTO_INCREMENT PRIMARY KEY, NAME VARCHAR(30) NOT NULL , ADDRESS VARCHAR(50) NOT NULL)")

my.commit()

def entry_表(n)：for x in range(0,n) :

user_name = input("ENTER NAME NUMBER {}: ".format(x+1))

user_state = input("ENTER STATE {} LIVES IN : ".format(user_name))

c.execute("INSERT INTO T1 (NAME , ADDRESS ) VALUES ( ? , ?)", user_name , user_state )

my.commit()

c.execute("SELECT * FROM T1")

myresult = c.fetchall()

for x in myresult:

print(x)

number=int(输入(“输入要填充的行数：”)

创建表()

条目表(编号)

c、 关闭()

我的。结束()