Databases

Post Example

Operations related to database configuration, connecting, data management, and data querying.

Install Database Management System

Grant Role to User

Create Database

Update Database

Delete Database

Update Table Column

Show Table Schema

Insert Row into Table

Insert Multiple Rows into Table

Get All Rows in Table

Query Rows Where Condition is True

Query Rows Ordered By Column

Query Rows Ordered By Multiple Columns

Query Rows with a Limit

Get Number of Rows before Limit

Query Grouped Rows

Query Grouped Rows with Group Condition

Query Rows by Joining Tables

Update Rows in Table

Delete Rows in Table

Export Database to SQL File

Export Database to Custom File

Import Database from SQL File

Import Database from Custom File

Full Text Search

Connect to Database

Query Tree Structure

Rename Table Column

Query Top Row in Each Group

Query TopN Rows in Each Group

Examples in Ruby

No examples yet.
You can see if there are examples in other languages or
be the first to post an example in Ruby!