Table of Contents

The SQL query plugin is perfectly suited for the direct execution of SQL commands and is therefore primarily interesting for users who already have experience with databases.

A big advantage of the plugin is that it accesses both the normal backend and the Big Data backend in the course of the database query.

Probably the most commonly used SQL command is the SELECT command, which is used to query entries. A simple query of the Name and Number columns from the Time table would look like this:

SELECT Name, Number FROM Time

After entering the command, the database is searched for the defined values and the results are automatically displayed in tabular form.

Results of a data query using the SQL command SELECT

Using the Export to new table function you can export the found data to a new table within the same Base.

Exporting the values found by SQL data query to a new table

Newly created table with the data previously found via SQL command with the plugin

DELETE is another frequently used command that is used to quickly delete entries. For example, the following command deletes all data from the Time table.

DELETE FROM Time

After entering the command, all entries are deleted from the Time table. However, you can restore the rows via the base log .

Entering the DELETE SQL command to delete table data.

SeaTable supports not all, but most of the SQL commands. For a complete list and more details, see the SeaTable Programming Manual .

Guide to the organization chart plugin All plugins at a glance