1. SQL Query
Description
The "SQL Query" function is a versatile tool that allows you to interact with databases using SQL (Structured Query Language). It opens a text file for editing SQL queries, executes the query on the specified database, and displays the results. This function provides a seamless way to retrieve and manipulate data, facilitating efficient data management within your SQLite databases.
Usage
- Open the terminal and type:
tt --db sqlquery [ARGS]
# or
tt -dbm sqlquery [ARGS]
Arguments
- --DB (Required)
Example:
tt --db sqlquery --DB C:\\Users\\MyUser\\ProjectName\\sqlite.db