abstra-docs
Search…
abstra-docs
Introduction to Abstra
Changelog
Security
Accessibility
Tutorials
Getting started
Lessons
Documentation
Front-end
Back-end
Connectors
Code
Storage
Airtable
Google Sheets
DynamoDB
E-mail
GraphQL
Microsoft SQL Server
MongoDB
MySQL
PostgreSQL
REST APIs
REST v2
SSH
Telegram
Project Settings
Powered By
GitBook
MySQL
Configuration
Queries
MySQL Queries
You can write regular
MySQL queries
here, for example:
1
SELECT * FROM "Users" u WHERE u.name LIKE '%John%'
Copied!
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:
1
SELECT * FROM "Users" u WHERE u.name = $name
Copied!
Insert example:
1
INSERT INTO "Users"(name, email) VALUES ($name,$email)
Copied!
Update example:
1
UPDATE "Users" SET name = $name WHERE u.email = $email
Copied!
Delete example:
1
DELETE FROM "Users" WHERE u.email = $email
Copied!
Previous
MongoDB
Next
PostgreSQL
Last modified
1yr ago
Copy link
Contents
MySQL Queries
Passing parameters to the query