Parameterized SQL statement: Difference between revisions
m
→{{header|Julia}}
mNo edit summary |
|||
Line 344:
name = "Smith, Steve"
jerseys = Dict("Smith, Steve" =>
BOOL(tf) = if(tf) "TRUE" else "FALSE" end
Line 356:
jerseynum integer)")
SQLite.query(db, "INSERT INTO players (name, score, active, jerseynum) values ('Jones, James', 9, 'FALSE',
SQLite.query(db, "UPDATE players SET name = ?, score = ?, active = ? WHERE jerseynum = ?";
Line 369:
│ Row │ id │ name │ score │ active │ jerseynum │
├─────┼────┼────────────────┼───────┼────────┼───────────┤
│ 1 │ 1 │ "Smith, Steve" │ 42 │ "TRUE" │
</pre>
| |||