Parameterized SQL statement: Difference between revisions
Content added Content deleted
No edit summary |
|||
Line 571: | Line 571: | ||
=={{header|Mathematica}}/{{header|Wolfram Language}}== |
=={{header|Mathematica}}/{{header|Wolfram Language}}== |
||
⚫ | |||
{{incorrect|Mathematica|Executing a NON-parameterized update DML. This solution is exactly the opposite of the task. This example is what is explicitly warned in the task.}} |
|||
⚫ | |||
⚫ | |||
SQLExecute[conn,"UPDATE players SET name = `1`, score = `2`, active = `3` WHERE jerseyNum = `4`", {SQLArgument["Smith, Steve",42,True,99]}] |
|||
⚫ | |||
SQLUpdate[conn,"players",{"name","score","active"},{"Smith, Steve", 42,"TRUE"},SQLColumn["jerseyNum"] = 99]; |
|||
CloseSQLConnection[conn];</lang> |
CloseSQLConnection[conn];</lang> |
||