​
Syntax for SQL commands

Follow the rules below when writing an SQL command.

  • Add a semi-colon ; at the end of each SQL command.
  • Use all-caps when writing the keywords, such as SELECT, FROM, JOIN, WHERE, GROUP BY, ORDER BY, PREDICT, AS, CREATE TABLE, INSERT INTO, etc.
  • When writing a query, start a new line for the following keywords: SELECT, FROM, JOIN, WHERE, GROUP BY, ORDER BY, PREDICT, USING, AND, OR. It is to avoid the horizontal scrollbar.

​
Example

SELECT *
FROM table_name_1 a
JOIN table_name_2 b
WHERE column_name_1=value_name_1
AND column_name_2=value_name_2
GROUP BY a.column_name_2
ORDER BY b.column_name_1;

​
Syntax for SQL commands along with their output

Follow the syntax below when documenting an SQL command and its output.

QUERY GOES HERE

On execution, we get:

+-------------+-------------+
| column_name | column_name |
+-------------+-------------+
| value       | value       |
+-------------+-------------+

Where:

NameDescription
VARIABLE NAME GOES HEREVARIABLE DESCRIPTION GOES HERE

If the output is not a table, remove the output table from above and place your output message there.

​
Example 1

SELECT *
FROM table_name_1 a
JOIN table_name_2 b
WHERE column_name=value_name;

On execution, we get:

+-------------+-------------+
| column_name | column_name |
+-------------+-------------+
| value       | value       |
+-------------+-------------+

Where:

NameDescription
column_namecolumn description

​
Output of Example 1

SELECT *
FROM table_name_1 a
JOIN table_name_2 b
WHERE column_name=value_name;

On execution, we get:

+-------------+-------------+
| column_name | column_name |
+-------------+-------------+
| value       | value       |
+-------------+-------------+

Where:

NameDescription
column_namecolumn description

​
Example 2

CREATE MODEL mindsdb.predictor_name
FROM integration_name
    (SELECT column_name_1, column_name_2, target_column FROM table_name)
PREDICT target_column;

On execution, we get:

OUTPUT GOES HERE

​
Output of Example 2

CREATE MODEL mindsdb.predictor_name
FROM integration_name
    (SELECT column_name_1, column_name_2, target_column FROM table_name)
PREDICT target_column;

On execution, we get:

OUTPUT GOES HERE