在MySQL语句中嵌入注释(Embedding comments in MySQL statements)

 有谁知道在MySQL语句中嵌入注释的方法吗？ 当我搜索mysql和评论时，我只能通过表格等方式发表评论 
 
 这个想法，如果我按照我的老板的意愿来实现这个想法，那么显然会在用户标识前添加一条语句，以便稍后（通过二进制日志）分析MySQL时，我们知道谁做了什么。 
 
 例： 
 SELECT id 
 从客户 
 WHERE句柄='JBH' 

 现在显示为： 
 - 用户：jwilkie 
 SELECT id 
 从客户 
 WHERE句柄='JBH' 
 
 （或类似） 
 
 编辑澄清：原因是我们有perl模块与MySQL连接，我们通过阅读$ ENV {USER}（本例中为“jwilkie”）来检索用户标识。 这是一种情况，我们有一个MySQL用户定义，但有多人运行perl mod。 
 
 有人对此有经验吗？ 非常感谢！ 简 

Does anyone know of a way to embed comments in MySQL statements? When I search for mysql and comments I get only ways to put comments in tables, etc 
 
The idea, if I implement this the way my boss wants it, is to prepend the user id to the statement apparently so that when MySQL is analyzed later (via the binary log) we know who did what.
 
Example:
 SELECT id
 FROM customer
 WHERE handle='JBH'
 
 Would now show up as:
 -- user:jwilkie
 SELECT id
 FROM customer
 WHERE handle='JBH' 
 
(or similar)
 
EDIT FOR CLARITY: The reason for this is that we have perl modules that are interfacing with MySQL and we are retrieving the user id by reading $ENV{USER} (which in this case is "jwilkie"). It is a situation where we have one MySQL user defined but multiple people running the perl mod.
 
Does anyone have experience with this? Many many thanks! Jane

原文：https://stackoverflow.com/questions/4100350