MySQL Forums
Forum List  »  General

Getting SQL code for prepared statements
Posted by: Omer Shapra
Date: January 27, 2009 12:24PM


I am a java developer working with MySQL.

I would like to see all prepared statements that are currently cached in the system, along with their SQL code.

For example, I can do the following in the MS SQL Server:

SELECT spid, db_name(s.dbid), text
FROM master.dbo.sysprocesses as s
cross apply ::fn_get_sql(s.sql_handle)

Here, I get text of all prepared statements from the system.

I need to know whether the same functionality exists in MySQL, and if so, how it can be used.

Any pointers to RTFM will be appreciated.


Options: ReplyQuote

Written By
Getting SQL code for prepared statements
January 27, 2009 12:24PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.