Online Documentation for SQL Manager for MySQL
Query parameters
Both SQL Editor and Visual Query Builder support parameters usage inside the query text. A parameter is a kind of variable for which a value can be specified just before the query execution. In the query text the parameter should appear as an identifier with a colon (':') at the beginning, e.g.
SELECT * FROM MYTABLE WHERE ID = :param1;
Note: The Allow using of parameters in query text option should be checked on the Tools page of the Environment Options dialog for this feature to be enabled.
See also: |