본문 바로가기

Python

[python] mysql query 수행이력 보기

반응형

sarc.io/index.php/mariadb/1737-mysql-python

 

Python으로 Mysql query 수행이력 보기

[{"id":"10","listid":"1","parentid":"0","videosource":"youtube","videoid":"KiwjxNKXfxY","imageurl":"https:\/\/i.ytimg.com\/vi\/KiwjxNKXfxY\/default.jpg,120,90;https:\/\/i.ytimg.com\/vi\/KiwjxNKXfxY\/mqdefault.jpg,320,180;https:\/\/i.ytimg.com\/vi\/KiwjxNKX

sarc.io

실행한 직전 sql 확인하기

# cursor._last_executed  는 없어졌다고 하는듯하다.
cursor.statement

dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-statement.html

 

MySQL :: MySQL Connector/Python Developer Guide :: 10.5.15 MySQLCursor.statement Property

10.5.15 MySQLCursor.statement Property Syntax: str = cursor.statement This read-only property returns the last executed statement as a string. The statement property can be useful for debugging and displaying what was sent to the MySQL server. The string

dev.mysql.com

 

https://24hours-beginner.tistory.com/145

 

[Python] MySQL 쿼리

실행한 직전 sql 확인하기 # cursor._last_executed 는 없어졌다고 하는듯하다. cursor.statement dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-statement.html MySQL :: MySQL Conne..

24hours-beginner.tistory.com

 

반응형

'Python' 카테고리의 다른 글

[PYTHON/AWS] BOTO3  (0) 2021.05.11
[Python] MySQL 쿼리  (0) 2021.05.03
[PYTHON] SSE (feat. Flask)(Server-Sent Events)  (0) 2021.04.20
[python] 제너레이터와 yield 알아보기  (0) 2021.04.20
[PYTHON] class 정리 - 상속(inheritance)  (0) 2021.04.19