What is SQL? Your first queries

Every FiveM server uses a database - for player data, vehicles, inventory, and money. SQL is the language you talk to it with. This lesson covers the four commands you'll use every day: SELECT to read, INSERT to create, UPDATE to change, and DELETE to remove. Four commands. That's it.

You'll build: Your first SQL queries: SELECT, INSERT, UPDATE, DELETE - the four commands every database interaction uses.
Time: ~20 minutes
You need: HeidiSQL connected to your standalone MariaDB database (see the QBCore server lesson).
You'll learn: What a relational database is, what tables/rows/columns are, the four SQL command types (CRUD), and how to write safe parameterized queries.

BEFORE YOU START

Build it

SELECT - read data

You can fetch any data from any table.

code

-- Get all players
SELECT * FROM players;

-- Get only the name and money columns
SELECT name, money FROM players;

-- Get players with money over 5000
SELECT name, money FROM players WHERE money > 5000;

-- Get the top 5 richest players
SELECT name, money FROM players ORDER BY money DESC LIMIT 5;

* means "all columns"
WHERE filters rows
ORDER BY sorts (DESC = highest first)
LIMIT caps the number of results

What is SQL? Your first queries

Build it

SELECT - read data

INSERT - create new data

UPDATE - change existing data

DELETE - remove data

Keep reading the full lesson