5,838
edits
Cumulus MX FAQ: Difference between revisions
m
→Using Custom SQL
| Line 112: | Line 112: | ||
Obviously to use Custom SQL you need some knowledge of SQL and this answer cannot teach you SQL. But the general format of an update instruction for a whole row is given below, ensure the command you supply to MX has all the parts shown. The instructions in {} are optional, they just make the SQL read better, parts in lower case need to be replaced by whatever is appropriate for your table, values are web tags enclosed in single quotes e.g. <tt>'<#windrun>'</tt>, if there are any columns for which you don't have a value, use NULL without any quotes as this is SQL. | Obviously to use Custom SQL you need some knowledge of SQL and this answer cannot teach you SQL. But the general format of an update instruction for a whole row is given below, ensure the command you supply to MX has all the parts shown. The instructions in {} are optional, they just make the SQL read better, parts in lower case need to be replaced by whatever is appropriate for your table, values are web tags enclosed in single quotes e.g. <tt>'<#windrun>'</tt>, if there are any columns for which you don't have a value, use NULL without any quotes as this is SQL. | ||
<pre> INSERT [INTO] database_table_name (primary_key_column_name, column_name_1, column_name_2, .... column_name_last) VALUES ('primary_key_value', 'web_tag_1', 'web_tag_2', ... 'web_tag_last'); | <pre> INSERT [INTO] database_table_name (primary_key_column_name, column_name_1, column_name_2, .... column_name_last) VALUES ('primary_key_value', 'web_tag_1', 'web_tag_2', ... 'web_tag_last');</pre> | ||
= Problems with web pages or NOAA reports = | = Problems with web pages or NOAA reports = | ||