Using Parameters

Skyvia supports parameters in queries. You can either use parameters in query filters or enter them in the SQL text of the query.

Parameter Names

When you specify parameter name in a filter condition, in visual query builder, you must specify the name, consisting of alphanumeric characters or underscore. Skyvia will automatically add the necessary prefix to it.

When you use a parameter in the SQL code, you should prefix the alphanumeric name with the colon ":" character for MySQL or with the "@" character for all other data sources.

note Note

You can use the colon ":" character for other sources too, if necessary. Additionally, for most data sources you can use unnamed parameters in the SQL statements, that are added as the "?" character.

Setting Parameter Values

Parameter values can be set and modified whenever necessary without changing the whole query. To specify values for query parameters, click the Parameters button on the toolbar. Skyvia Query will detect all the parameters, used in the query, and display their list, allowing you to select a data type and specify a value for each of them. After this, you can either apply parameter changes or cancel them, using the Apply or Cancel buttons respectively.

query-edit-parameters