5,838
edits
Cumulus.ini: Difference between revisions
m
no edit summary
m (Minor resequencing of page) |
mNo edit summary |
||
|
| 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:
<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>' ....);
BEGIN NOT ATOMIC
IF '<#web tag>' = '---' THEN
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>';
END IF
END
</pre>
| |||