Getting SQL code for prepared statements

[Omer Shapra]

Hello,

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.

Thanks