Parameterized SQL statement: Difference between revisions

=={{header|Nim}}==

Using an SQLite in memory database and "db_sqlite" high level binding from standard library.

<lang Nim>import db_sqlite

let db = open(":memory:", "", "", "")

# Setup

db.exec(sql"CREATE TABLE players (name, score, active, jerseyNum)")

db.exec(sql"INSERT INTO players VALUES (?, ?, ?, ?)", "name", 0, "false", 99)

# Update the row.

db.exec(sql"UPDATE players SET name=?, score=?, active=? WHERE jerseyNum=?",

"Smith, Steve", 42, true, 99)

# Display result.

for row in db.fastRows(sql"SELECT * FROM players"):

echo row

db.close()</lang>

{{out}}

<pre>@["Smith, Steve", "42", "true", "99"]</pre>