sqlalchemy.exc.ProgrammingError: (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 'fromt_user' at line 1")

報(bào)錯(cuò)是這樣的，意思就是我的sql語(yǔ)法出錯(cuò)了

今天在弄pandas連接mysql數(shù)據(jù)庫(kù)的時(shí)候，最后運(yùn)行時(shí)出錯(cuò)了

源代碼：

from sqlalchemy import create_enginedef query(table):host = 'localhost'user = 'root'password = '123456'database = 'ConstructionDB'port = 3306conn = create_engine('mysql+pymysql://{}:{}@{}:{}/{}'.format(user, password, host, port, database))sql = 'select * from' + tableresults = pd.read_sql(sql, conn)return results

通過(guò)debug發(fā)現(xiàn)，原來(lái)sql語(yǔ)句在拼接的時(shí)候沒(méi)有空格，導(dǎo)致sql最后的語(yǔ)法時(shí)

sql = [select * fromt_user]

沾一塊去了

def query(table):host = 'localhost'user = 'root'password = '123456'database = 'ConstructionDB'port = 3306conn = create_engine('mysql+pymysql://{}:{}@{}:{}/{}'.format(user, password, host, port, database))sql = 'select * from' +' ' + tableresults = pd.read_sql(sql, conn)return results

注意?sql語(yǔ)句?，把代碼中間? 拼接一個(gè)空格? 即可，問(wèn)題解決

總結(jié)

以上是生活随笔為你收集整理的sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1064, “You have an error in your SQ的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。