Prisma•2y ago

Adding arguments to rawQueryTyped with MySql

The docs mention that you can add arguments to rawQueryTyped queries https://www.prisma.io/docs/orm/prisma-client/using-raw-sql/typedsql#passing-arguments-to-typedsql-queries

SELECT id, name, age
FROM users
WHERE age > ? AND age < ?

SELECT id, name, age
FROM users
WHERE age > ? AND age < ?

I'm pretty inexperienced with raw sql, so I have a few questions:
1. The docs show the example of

getUsersByAge(minAge, maxAge)

getUsersByAge(minAge, maxAge)

. How exactly are the variables

minAge, maxAge

minAge, maxAge

mapped to the positional placeholders? is it based on the order that the placeholders appear?
2. What if I want to use a parameter multiple times? Will I have to pass in the parameter multiple times?
3. Is there a way to pass in the parameter, set it to a variable name in the SQL script, and reuse the variable name?

Writing Type-safe SQL with TypedSQL and Prisma Client | Prisma Docu...

Learn how to use TypedSQL to write fully type-safe SQL queries that are compatible with any SQL console and Prisma Client.

Prisma•2y ago

josh taylor

Adding arguments to rawQueryTyped with MySql

The docs mention that you can add arguments to rawQueryTyped queries https://www.prisma.io/docs/orm/prisma-client/using-raw-sql/typedsql#passing-arguments-to-typedsql-queries

SELECT id, name, age
FROM users
WHERE age > ? AND age < ?

SELECT id, name, age
FROM users
WHERE age > ? AND age < ?

I'm pretty inexperienced with raw sql, so I have a few questions:
1. The docs show the example of

getUsersByAge(minAge, maxAge)

getUsersByAge(minAge, maxAge)

. How exactly are the variables

minAge, maxAge

minAge, maxAge

Writing Type-safe SQL with TypedSQL and Prisma Client | Prisma Docu...

Learn how to use TypedSQL to write fully type-safe SQL queries that are compatible with any SQL console and Prisma Client.

Adding arguments to rawQueryTyped with MySql

Similar Threads

Adding arguments to rawQueryTyped with MySql

Similar Threads

Similar Threads

Similar Threads