Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How to Convert CSV to SQL INSERT Statements

Convert CSV or Excel-exported data into SQL CREATE TABLE and INSERT statements for MySQL, PostgreSQL, SQLite, SQL Server, or Oracle, with type inference and safe batching.

How to Run SQLite Online in Your Browser (No Installation)

Run SQLite online without installing a database server. Use a browser-based SQLite playground to execute SQL, open local .db files, test queries, and export changes privately.

SQL Bulk and Batch Insert by Database: Syntax, Limits & Performance

Compare multi-row batch insert syntax, row constructor limits, and bulk loading methods across MySQL, MariaDB, PostgreSQL, SQLite, SQL Server, and Oracle.

SQL JSON Aggregation by Database: Arrays and Objects

Compare JSON array and object aggregation in MySQL, MariaDB, PostgreSQL, SQLite, SQL Server, and Oracle, including ordering, NULL, and version differences.

List Views in SQL: MySQL, MariaDB, PostgreSQL & More

Compare how to list views in MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and Oracle, including schemas, system views, and permissions.

JSON Schema Validation in MySQL and MariaDB

Compare MySQL and MariaDB JSON_SCHEMA_VALID(): minimum versions, Draft 4 versus Draft 2020, reference limits, and MySQL validation reports.

List Databases in SQL: MySQL, MariaDB, PostgreSQL & More

Compare how MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and Oracle list databases, schemas, or attached files, including visibility limits.

How to List Tables in SQL Server (T-SQL and SSMS)

List SQL Server tables in the current database with T-SQL or SSMS, include schemas, filter by schema, and troubleshoot missing results.

List Indexes in SQL: MySQL, MariaDB, PostgreSQL & More

Compare how to inspect a table’s indexes in MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and Oracle.

List Table Columns in SQL: MySQL, MariaDB, PostgreSQL & More

Compare how to inspect table columns in MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and Oracle, including data types and nullability.