Search results
OxMySQL is a replacement of mysql-async and ghmattimysql with expanded API and improved compatibility for MySQL 8. Learn how to install, configure, use and debug OxMySQL for your FiveM or RedM server.
- Transaction
A transaction executes multiple queries and commits them...
- Query
Query. When selecting data, returns all matching rows and...
- Oxmysql
Update. Returns the number of rows affected by the query....
- Single
Single. Returns all selected columns for a single row. Lua...
- Using the Debug UI
OxMySQL Using the Debug UI The debug UI lets you easily see...
- Prepare
Prepare. Prepare can be used to execute frequently called...
- Scalar
Scalar. Returns the first column for a single row. Lua JS....
- rawExecute
RawExecute. rawExecute can be used to execute frequently...
- Transaction
Download the latest release directly. 📚 Documentation. For installation, setup, and everything else. 📦 npm. Use our npm package for enhanced functionality and TypeScript support. Features. Support for mysql-async and ghmattimysql syntax. Promises / async query handling allowing for non-blocking and awaitable responses.
📚 Documentation. For installation, setup, and everything else. 📦 npm. Use our npm package for enhanced functionality and TypeScript support. Features. Support for mysql-async and ghmattimysql syntax. Promises / async query handling allowing for non-blocking and awaitable responses. Improved performance and stability compared to other options.
💾 Download. Download the latest release directly. 📚 Documentation. For installation, setup, and everything else. 📦 npm. Use our npm package for enhanced functionality and TypeScript support. Features. Support for mysql-async and ghmattimysql syntax. Promises / async query handling allowing for non-blocking and awaitable responses.
Installation. We strongly recommend referring to Guides to setup necessary development tools. Install all resource dependencies. oxmysql. ox_lib. Download the latest release or build the source code. Setup Git, Node.js, and pnpm. Download and setup MariaDB 11.4+ (opens in a new tab) .
Resources can import oxmysql methods by including our library, granting some type-checking and minor performance improvements over raw export calls. Lua Modify fxmanifest.lua for your resource, and add the following above any other script files.
A transaction executes multiple queries and commits them only if all succeed. If one fails, none of the queries are committed. The return value is a boolean, which is the result of the transaction.