/SQL/How to define a save method in ruby for sqlite3 databases

How to define a save method in ruby for sqlite3 databases

def save
    sql = <<-SQL
      INSERT INTO songs (name, album) 
      VALUES (?, ?)
    SQL
 
    DB[:conn].execute(sql, self.name, self.album)
 
    @id = DB[:conn].execute("SELECT last_insert_rowid() FROM songs")[0][0]
 
  end

Similar codes

11 votes102 views2 answers
Sql rank
SQL
0 vote98 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
4 votes142 views1 answer
How to check last gather stats on table in oracle
SQL
1 vote121 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
2 votes113 views1 answer
Create delete procedure mysql
SQL
2 votes95 views4 answers
Mysql select into new table
SQL
0 vote56 views1 answer
Kannst du deine finger trainieren
SQL
2 votes104 views1 answer
How to check if a row is null in sql
SQL
0 vote99 views1 answer
Last date for each user sql
SQL
6 votes99 views4 answers
Sqlite drop table
SQL