This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Query status information message

Hello, I would like to know how I can get the output message that appears in the mariaDB prompt after executing a query and saving it in a variable, I am using python

/* Records affected: 0 Records found: 0 Warnings: 0 Duration of 1 query: 0.015 Mon. */

thank you very much

Answer Answered by Daniel Black in this comment.

There is status_info as a connection property. warnings is a connection protocol property from the ok_packet. capabilties at connection.

cursor.affected_rows for the affected rows.

The MariaDB monitor implement its own timing.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.