Parameterized SQL statement: Difference between revisions
Content added Content deleted
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 │
|