Results for “syntax-differences”
13 skills
mariadb-corporation mysql-to-mariadb
Guides developers migrating applications from MySQL to MariaDB, covering authentication, JSON handling, replication, and SQL syntax differences.
0
tools-only 062-sql-5eac1a75
Explains syntax differences for common SQL operations across PostgreSQL, MySQL, SQL Server, and Oracle, including auto-increment keys, string concatenation, date functions, pagination, booleans, JSON, case sensitivity, and recursive CTEs.
7 · bundle
mariadb-corporation mariadb-set
Explains MariaDB-specific SET syntax and behavior, including scope rules, the SET STATEMENT ... FOR extension, and persistence differences from MySQL.
0
More results
mariadb-corporation mariadb-update
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.
0
arustydev lang-sql-dev
Foundational SQL patterns for query writing, schema design, and dialect differences. Use when writing SQL queries, designing database schemas, understanding SQL syntax across PostgreSQL/MySQL/SQLite, or preparing SQL for conversion to other query languages. This is a meta-skill for SQL derivatives.
8
mariadb-corporation mariadb-delete
Covers MariaDB-specific DELETE syntax and behavior, including RETURNING, multi-table forms, temporal-table deletion, and DELETE vs TRUNCATE differences.
0
mariadb-corporation mariadb-create-view
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.
0
mariadb-corporation mariadb-create-database
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.
0
mariadb-corporation mariadb-alter-table
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.
0
mariadb-corporation mariadb-string-functions
Reference for MariaDB string functions: extraction, length, search, concatenation, modification, case, PCRE2 regex, formatting, and encoding, with common pitfalls and version notes.
0
mariadb-corporation mariadb-select
Covers MariaDB-specific SELECT syntax and behavior, including optimizer hints, LIMIT extensions, row locking, temporal queries, and file output.
0
mariadb-corporation mariadb-load-data
Explains MariaDB-specific syntax and behavior for LOAD DATA [LOCAL] INFILE and LOAD XML, including LOCAL vs server-side file handling, security and privilege requirements, default tab/newline parsing, duplicate and strict-mode caveats, IGNORE n LINES, user-variable SET transforms, CHARACTER SET clause, and priority.
0
mariadb-corporation mariadb-create-function
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.
0