Contribute
Style Guide for MindsDB Documentation
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:
Name | Description |
---|---|
VARIABLE NAME GOES HERE | VARIABLE 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:
Name | Description |
---|---|
column_name | column 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:
Name | Description |
---|---|
column_name | column 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
Was this page helpful?