Practice sqlalchemy, the original database file copy and paste from other place, now use read_sql_query error, please reply


The from sqlalchemy import create_engine
Engine=create_engine (' mysql + pymysql://root: 1234 @127.0.0.1: \
3306/testdb? Charset=utf8 ')
Print (engine)

The import pandas as pd
Formlist=pd. Read_sql_query (' show tables, con=engine)
Print (' testdb database tables listing is: ', '\ n' formlist)

This is dozen code
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
This is an error content
'Engine' object has no attribute 'cursor'