Cumulus.ini: Difference between revisions
From Cumulus Wiki
Jump to navigationJump to search
m (Minor resequencing of page) |
mNo edit summary |
||
Line 2,299: | Line 2,299: | ||
| Determine which file read (and therefore which table updated, using table names set in table name parameters explained in next table) | | Determine which file read (and therefore which table updated, using table names set in table name parameters explained in next table) | ||
|} | |} | ||
WARNING: The SQL syntax for [https://mysqlconnector.net/ "My SQL Connector"] used by .NET and therefore by MX, differs in various ways from the MySQL Client or MARIA db syntax. | |||
Here is an example of what might be input as "predetermined SQL", showing how you can use conditionals and web tags: | Here is an example of what might be input as "predetermined SQL", showing how you can use conditionals and web tags: | ||
<pre> | <pre> | ||
INSERT IGNORE INTO table_name_1 (primary_key, column_name_1, column_name_2 ....) VALUES ('<#primary_key>', '<#web tag_name_1 modifier_1>', '<#web tag_name_2 modifier_2>' ....); | INSERT IGNORE INTO table_name_1 (primary_key, column_name_1, column_name_2 ....) VALUES ('<#primary_key>', '<#web tag_name_1 modifier_1>', '<#web tag_name_2 modifier_2>' ....); | ||
BEGIN NOT ATOMIC | BEGIN NOT ATOMIC | ||
IF '<#web tag>' = '---' THEN | IF '<#web tag>' = '---' THEN | ||
Line 2,309: | Line 2,311: | ||
ELSE | ELSE | ||
UPDATE table_name_2 SET column_name_1 = '<#web tag_name_1 modifier_1>', column_name_2 = '<#web tag_name_2 modifier_2>' .... WHERE primary_key = '<#primary_key>'; | UPDATE table_name_2 SET column_name_1 = '<#web tag_name_1 modifier_1>', column_name_2 = '<#web tag_name_2 modifier_2>' .... WHERE primary_key = '<#primary_key>'; | ||
END IF | END IF | ||
END | END; | ||
</pre> | </pre> | ||