Revision as of 17:04, 13 August 2021 (view source) Shuisman (talk \| contribs) m (→‎{{header\|Mathematica}}) ← Older edit		Revision as of 17:14, 13 August 2021 (view source) Shuisman (talk \| contribs) No edit summary Newer edit →
Line 571: =={{header\|Mathematica}}/{{header\|Wolfram Language}}== <lang Mathematica>Needs["DatabaseLink`"]; ▼ ~~{{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.}}~~ conn=OpenSQLConnection[JDBC["ODBC(DSN)", "testdb"], "Username" -> "John", "Password" -> "JohnsPassword"];▼ ▲<lang Mathematica>Needs["DatabaseLink`"]; SQLExecute[conn,"UPDATE players SET name = `1`, score = `2`, active = `3` WHERE jerseyNum = `4`", {SQLArgument["Smith, Steve",42,True,99]}] ▲conn=OpenSQLConnection[JDBC["ODBC(DSN)", "testdb"], "Username" -> "John", "Password" -> "JohnsPassword"]; ~~SQLUpdate[conn,"players",{"name","score","active"},{"Smith, Steve", 42,"TRUE"},SQLColumn["jerseyNum"] = 99];~~ CloseSQLConnection[conn];</lang>

Parameterized SQL statement: Difference between revisions

Parameterized SQL statement (view source)