Anonymous user
Parameterized SQL statement: Difference between revisions
→{{header|Julia}}
Line 339:
=={{header|Julia}}==
{{works with|Julia|0.6}}
Uses the SQLite package.
<lang
name = "Smith, Steve"
jerseys = Dict("Smith, Steve" => 99)
▲BOOL(tf) = if(tf) "TRUE" else "FALSE" end
db = SQLite.DB() # no filename given, so create an in-memory temporary
▲SQLite.execute!(db, "create table players (id integer primary key,
▲ active bool,
jerseynum integer)")
SQLite.query(db, "INSERT INTO players (name, score, active, jerseynum) values ('Jones, James', 9, 'FALSE', 99)")
SQLite.query(db, "UPDATE players SET name = ?, score = ?, active = ? WHERE jerseynum = ?";
values = ["Smith, Steve", 42,
tbl = SQLite.query(db, "SELECT * from players")
println(tbl)</lang>▼
▲println(tbl)
{{output}}<pre>
1×5 DataFrames.DataFrame
| |||