| Use parameterized queries with SQL |
Use parameterized queries to prevent injection attacks and make queries more reusable.
|
404 |
| influxdb3_core |
| name |
parent |
identifier |
| Parameterized queries |
Query with SQL |
parameterized-queries-sql |
|
|
|
##### Using Go and the influxdb3-go client
```go
// Use the $parameter syntax to reference parameters in a query.
// The following SQL query contains $room and $min_temp placeholders.
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.
iterator, err := client.QueryWithParameters(context.Background(), query, parameters)
```
|
/shared/influxdb3-query-guides/sql/parameterized-queries.md |