Module 07 · Lesson 21

SQL from zero: oxmysql

Every script you have built so far forgets everything on restart. Cooldowns, bank balances, notes -- all gone. A database is the fix. It is a separate program that stores rows of data on disk and gives them back when you ask. This lesson teaches you just enough SQL to make your FiveM scripts remember things forever, using oxmysql as the bridge between your Lua and the database.

You'll ship: A working resource that creates a table, inserts a row with a safe parameterized query, reads it back, and updates it.
Time: ~35 minutes
You'll learn: What a database is -> install oxmysql -> CREATE TABLE -> INSERT with ? placeholders -> read one row -> UPDATE, and what .await actually does
Prereqs: Modules 01-06 complete. A running FiveM server with MariaDB or MySQL installed, and the oxmysql resource downloaded.

Alphi: SQL, JS, Lua, and Git masterclass.

BEFORE YOU START

Build it

Make the resource folder

The server has one folder for this lesson.

SQL from zero: oxmysql

Build it

Make the resource folder

Create the files

Point oxmysql at your database

Write fxmanifest.lua

Create the table

Write the lesson code

Start and test it

Keep reading the full lesson