Changeset 19116 for trunk

Timestamp:

07/31/18 21:09:27 (6 years ago)

Author:

tbretz

Message:

Adapted help text

Location:

trunk/FACT++/src

Files:

• fits2sql.cc (modified) (1 diff)
• root2sql.cc (modified) (1 diff)

trunk/FACT++/src/fits2sql.cc

@@ -147 +147 @@
         "\n"
         "Usually, the INSERT query would fail if the PRIMARY key exists already. "
-        "This can be avoided using the 'ON DUPLICATE KEY' directive. With the "
+        "This can be avoided using the 'ON DUPLICATE KEY UPDATE' directive. With the "
         "--duplicate, you can specify what should be updated in case of a duplicate key. "
         "To keep the row untouched, you can just update the primary key "
         "with the identical primary key, e.g. --duplicate='MyPrimary=VALUES(MyPrimary)'. "
-        "For more details, see the MySQL manual.\n"
+        "The --duplicate resource can be specified more than once to add more expressions "
+        "to the assignment_list. For more details, see the MySQL manual.\n"
         "\n"
         "Another possibility is to add the IGNORE keyword to the INSERT query by "

trunk/FACT++/src/root2sql.cc

@@ -154 +154 @@
         "\n"
         "Usually, the INSERT query would fail if the PRIMARY key exists already. "
-        "This can be avoided using the 'ON DUPLICATE KEY' directive. With the "
-        "--duplicate,you can specify what should be updated in case of a duplicate key. "
+        "This can be avoided using the 'ON DUPLICATE KEY UPDATE' directive. With the "
+        "--duplicate, you can specify what should be updated in case of a duplicate key. "
         "To keep the row untouched, you can just update the primary key "
         "with the identical primary key, e.g. --duplicate='MyPrimary=VALUES(MyPrimary)'. "
-        "For more details, see the MySQL manual.\n"
+        "The --duplicate resource can be specified more than once to add more expressions "
+        "to the assignment_list. For more details, see the MySQL manual.\n"
         "\n"
         "For debugging purpose, or to just create or drop a table, the final insert "