Results for “mariadb”

Guides developers migrating applications from MySQL to MariaDB, covering authentication, JSON handling, replication, and SQL syntax differences.

Documents MariaDB-specific GRANT behavior, including privilege scope levels, implicit account creation, MariaDB-only privileges, roles, proxy grants, resource limits, and TLS options, to help write accurate GRANT statements.

Explains MariaDB-specific features and behaviors that differ from MySQL, including system-versioned tables, RETURNING, sequences, and version-specific defaults, to help optimize and migrate MariaDB applications.

Explains MariaDB server-side prepared statements (PREPARE, EXECUTE, DEALLOCATE, EXECUTE IMMEDIATE), including syntax, allowed statements, placeholders, session scope, and restrictions. Use when writing or reviewing dynamic SQL for MariaDB.

Guides writing MariaDB-specific database create scripts with best practices for schema objects, session settings, and UUID usage.

Explains MariaDB's three CREATE FUNCTION forms — stored functions, stored aggregate functions, and loadable UDFs — covering syntax, privileges, and behavior differences for writing or reviewing MariaDB SQL.

Decodes and replays MariaDB binary logs with correct flags: commented pseudo-SQL vs. executable BINLOG blobs, ANNOTATE_ROWS events, flashback undo SQL, and safe replay via the mariadb client.

Catalog of MariaDB JSON functions with signatures and semantics, covering constructors, extraction, modification, merging, validation, introspection, and formatting. Use when writing SQL that builds, queries, or alters JSON data in MariaDB.

Explains MariaDB-specific EXPLAIN and ANALYZE syntax, including FORMAT=JSON, SHOW EXPLAIN/ANALYZE FOR, and the standalone ANALYZE statement that executes queries.

Explains MariaDB-specific view syntax and behavior, including CREATE OR REPLACE VIEW, ALGORITHM options, SQL SECURITY, updatability rules, and WITH CHECK OPTION, for writing or reviewing MariaDB view statements.

Explains MariaDB-specific SHOW statement syntax, including replication terminology, filtering rules, and diagnostic commands like SHOW EXPLAIN and SHOW ANALYZE.

Reference for MariaDB string functions: extraction, length, search, concatenation, modification, case, PCRE2 regex, formatting, and encoding, with common pitfalls and version notes.

Explains MariaDB-specific SET syntax and behavior, including scope rules, the SET STATEMENT ... FOR extension, and persistence differences from MySQL.

Covers MariaDB-specific DELETE syntax and behavior, including RETURNING, multi-table forms, temporal-table deletion, and DELETE vs TRUNCATE differences.

Covers MariaDB-specific behavior of the mariadb command-line client, including batch mode output, delimiter handling, safe-updates, charset detection, and TLS defaults, for writing or reviewing shell commands and scripts.

Documents MariaDB-specific UPDATE syntax and behavior, including single-table vs multi-table forms, assignment evaluation order, RETURNING with OLD_VALUE(), temporal tables, and common pitfalls. Use when writing, generating, or reviewing UPDATE statements targeting MariaDB.

Explains MariaDB Connector/Python's DB API 2.0 behavior, including qmark placeholders, autocommit, prepared statements, buffered cursors, connection pooling, and error handling, for writing and reviewing Python code that uses the mariadb module.

Provides MariaDB-specific syntax and behavior for CREATE, ALTER, and DROP DATABASE statements, including OR REPLACE vs IF NOT EXISTS, charset and collation defaults, and the absence of RENAME DATABASE.

Covers MariaDB-specific SELECT syntax and behavior, including optimizer hints, LIMIT extensions, row locking, temporal queries, and file output.

Reference for MariaDB window functions and the OVER clause, covering ranking, value navigation, and ordered-set functions with syntax and common pitfalls.

Covers MariaDB-specific ALTER USER and SET PASSWORD syntax, including IF EXISTS semantics, authentication methods, password expiration, account locking, and resource limits.

Documents MariaDB-specific transaction control syntax and behavior, including START TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT, implicit commit rules, autocommit defaults, and idle transaction timeouts.

Reference for MariaDB numeric and math functions, covering rounding, division, powers, logs, trigonometry, randomness, base conversion, checksums, and formatting, with guidance on exact-vs-approximate types and division-by-zero behavior.

Documents MariaDB-specific ALTER TABLE syntax and behavior, including online DDL algorithms, lock modes, lock timeouts, idempotent subclauses, system versioning, and partition operations, for writing and reviewing schema migrations.

Reference for MariaDB aggregate functions, covering counting, totals, extrema, string and bitwise aggregation, and statistical functions, with guidance on NULL handling and common pitfalls.

Explains MariaDB-specific behavior of DROP USER and RENAME USER, including multiple accounts per statement, IF EXISTS handling, active-connection warnings, and effects on privileges and definers. Use when writing or reviewing account-lifecycle SQL for MariaDB.

Installs and configures MariaDB Connector/ODBC, covering driver manager registration, DSN setup, connection-string keywords, and TLS options for Linux, macOS, and Windows.

Reference for MariaDB's built-in date and time functions, covering current time, arithmetic, differences, extraction, parsing, formatting, Unix time, time-zone conversion, construction, and Oracle-compatible helpers, with guidance on version-specific behavior and common pitfalls.

Explains MariaDB-specific CREATE INDEX and DROP INDEX syntax, including mapping to ALTER TABLE, prefix lengths for TEXT/BLOB, lack of expression indexes, real descending indexes, IGNORED indexes, and index kinds. Use when writing or reviewing index statements for MariaDB.

Documents MariaDB-specific INSERT syntax and behavior, including RETURNING, ON DUPLICATE KEY UPDATE, INSERT IGNORE, and various forms and modifiers, to help write and review INSERT statements.