Other databases
Articles in the Other databases category (4).
Articles in the Other databases category (4).
- Filtering the last 24 hours across SQL engines — Equivalent date conditions for the last 24 hours in MySQL, SQL Server, Oracle, PostgreSQL, Redshift, SQLite and MS Access.
- MongoDB: structure of the _id field (ObjectId) — Breakdown of the 12 bytes of a MongoDB ObjectId: timestamp, machine, process and counter.
- SQL command types: DDL, DQL, DML, DCL and TCL — The five SQL statement categories, their purpose and the typical commands of each.
- SQL: command types DML, DDL, DCL and TCL — Memo of the four SQL command families and the statements they group.