Parameterized SQL statement: Difference between revisions
m
no edit summary
mNo edit summary |
|||
Line 352:
SQLite.execute!(db, "create table players (id integer primary key,
name text,
score number,
active bool,
jerseynum integer)")
SQLite.query(db, "INSERT INTO players (name, score, active, jerseynum) values ('Jones, James',
SQLite.query(db, "UPDATE players SET name = ?, score = ?, active = ? WHERE jerseynum = ?";
Line 363:
tbl = SQLite.query(db, "SELECT * from players")
println
</lang>
{{
1×5 DataFrames.DataFrame
│ Row │ id │ name │ score │ active │ jerseynum │
|