代碼如下：
#給出股票的名字和id，在資料庫中創建表格
def establish_table(sto_id, sto_name): # 輸入兩個字串
table_name = sto_id + sto_name
cursor = db.cursor()
cursor.execute("USE stock_lists")
cursor.execute("DROP TABLE IF EXISTS %s" , (table_name))
sql = """
CREATE TABLE whatever
(
date DATE,
HolderNum VARCHAR(255),
ClosePrice VARCHAR(255)
)"""
cursor.execute(sql)
cursor.execute("RENAME TABLE whatever TO %s" , (table_name))
db.commit()
cursor.close()
return table_name
報錯顯示：
Traceback (most recent call last):
File "E:/paqu/paqu12.py", line 148, in <module>
table_name = establish_table(stock[0], stock[1])
File "E:/paqu/paqu12.py", line 57, in establish_table
cursor.execute("DROP TABLE IF EXISTS %s" , (table_name))
File "E:\xuniproject\venv\lib\site-packages\pymysql\cursors.py", line 170, in execute
result = self._query(query)
File "E:\xuniproject\venv\lib\site-packages\pymysql\cursors.py", line 328, in _query
conn.query(q)
File "E:\xuniproject\venv\lib\site-packages\pymysql\connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "E:\xuniproject\venv\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
result.read()
File "E:\xuniproject\venv\lib\site-packages\pymysql\connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "E:\xuniproject\venv\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
packet.check_error()
File "E:\xuniproject\venv\lib\site-packages\pymysql\protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "E:\xuniproject\venv\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, "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")
Process finished with exit code 1
求大神幫忙解答
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/32789.html
標籤：疑難問題