| Use parameterized queries with InfluxQL |
Use parameterized queries to prevent injection attacks and make queries more reusable.
|
404 |
| influxdb3_core |
| name |
parent |
identifier |
| Parameterized queries |
Query with InfluxQL |
parameterized-queries-influxql |
|
|
|
##### Using Go and the influxdb3-go client
```go
// Use the $parameter syntax to reference parameters in a query.
// The following InfluxQL query contains $room and $min_time parameters.
query := `
SELECT * FROM home
WHERE time >= $min_time
AND temp >= $min_temp
AND room = $room`
// Assign parameter names to input values.
parameters := influxdb3.QueryParameters{
"room": "Kitchen",
"min_temp": 20.0,
"min_time": "2024-03-18 00:00:00.00",
}
// Call the client's function to query InfluxDB with parameters and the
// the InfluxQL QueryType.
iterator, err := client.QueryWithParameters(context.Background(),
query,
parameters,
influxdb3.WithQueryType(influxdb3.InfluxQL))
```
|
true |
/shared/influxdb3-query-guides/influxql/parameterized-queries.md |