How to use the command "dolt sql" (with examples)

The “dolt sql” command allows users to run SQL queries in a Dolt database. It provides a way to retrieve, modify, and manage data stored in Dolt tables using SQL statements. This command is especially useful for users who are familiar with SQL and want to work with Dolt databases using their SQL knowledge.

Use Case 1: Run a single query

Code:

dolt sql --query "INSERT INTO t values (1, 3);"

Motivation: Users may want to insert new data into a Dolt table using a SQL query. By running a single query, users can easily add new records to an existing table.

Explanation:

• dolt sql: The command to run a SQL query in Dolt.
• --query: Specifies a SQL query to be executed.
• "INSERT INTO t values (1, 3);": An example SQL query that inserts a new row with values 1 and 3 into the table “t”.

Example output:

Rows affected: 1

Use Case 2: List all saved queries

Code:

dolt sql --list-saved

Motivation: Users may want to view a list of all the saved queries in a Dolt database. This can be helpful for managing and organizing saved queries.

Explanation:

• dolt sql: The command to run a SQL query in Dolt.
• --list-saved: Lists all saved queries in the Dolt database.

Example output:

Saved queries:
1. my_query_1  SELECT * FROM t;
2. my_query_2  SELECT column FROM t;

Conclusion:

The “dolt sql” command is a powerful tool for working with Dolt databases using SQL queries. It allows users to perform various operations on Dolt tables, such as inserting data and retrieving saved queries. By leveraging their SQL knowledge, users can easily interact with Dolt databases and perform complex data manipulations.