Code Factory for MySQL online Help

Return to chapter overview

Both SQL Editor and Visual Query Builder admit to using parameters inside the query text. A parameter is a kind of variable. Its value can be specified just before the query execution in the Parameters window. In the query text the parameter should appear as an identifier with a colon (':') at its beginning, e.g. :param1.

The Parameters dialog is used to specify the query parameters as well as values of the input parameters of procedures or functions before the execution. Enter parameter values and click the OK button to apply the values and execute the query or use the Cancel button to abort the execution.

Note: To allow use parameters in query text, check the corresponding option at the Tools tab of Code Factory for MySQL Options.

Return to chapter overview

SQL Maestro Group wishes you a happy Thanksgiving!

We are pleased to grant you a 20% discount for all our products and bundles till the end of November!

Company news

Apr 10, 2017

Code Factories advanced to version 17.4

New version features colored tabs, new encryption algorithms in data grids, enhanced data input forms, updated data export/import tools and a lot of other useful things.

Sep 20, 2013

Code Factories are updated to version 13.9

New version comes with keyboard interactive SSH authentication, updated Script Runner, redesigned start page, improved SQL editors and data grids, as well as with many other useful things.

Mar 5, 2012

Code Factories advanced to version 12.3

New version introduces Unicode support in editors, updated code folding appearance, viewing BLOB data as PDF, data import from ODBC data source, Spanish translation and a lot of other new features.

More news

Feature of the day

BLOB Viewer

Using MySQL Code Factory you can view or edit BLOB data in the following ways: hexadecimal dump, plain text, graphical image or HTML page.

Multi-threading query execution

MySQL Code Factory allows you to execute each query in a separate thread in order to continue your work with the software while the query is executing.

Code Factory for MySQL online Help

Query Parameters

Thanksgiving Sale