app_name and @@procid equivalents

[Cedric Baelemans]

Hi,

I'm looking for the equivalents in MySQL for two SQL Server functions/variables.

1. app_name() : returns the name of the application connected, e.g. "SQL server studio express"

2. @@procid : the id of the stored proc that inserts/updates the record. With the function object_name(@@procid), you can get the name instead of the id.

I use both in an audit trail mechanism, so I can trace back how the record was changed. And for debugging, it has also proved its use. I hope something similar exists in MySQL.

Cedric