abstra-docs
Search
⌃K

MySQL

Configuration
Queries

MySQL Queries

You can write regular MySQL queries here, for example:
SELECT * FROM "Users" u WHERE u.name LIKE '%John%'

Passing parameters to the query

You can add params to your query by naming them $variable. When you use this query in the frontend, you can dinamically fill the parameters:
SELECT * FROM "Users" u WHERE u.name = $name
Insert example:
INSERT INTO "Users"(name, email) VALUES ($name,$email)
Update example:
UPDATE "Users" SET name = $name WHERE u.email = $email
Delete example:
DELETE FROM "Users" WHERE u.email = $email
Last modified 2yr ago