/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

0 vote145 views1 answer
Sql describe
SQL
0 vote127 views4 answers
Mysql select bottom 10 rows
SQL
0 vote135 views1 answer
Search starting with mysql
SQL
2 votes134 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote133 views1 answer
Left join vs inner join performance
SQL
0 vote127 views1 answer
Mysql identified by syntax error
SQL
0 vote136 views1 answer
Mysql terminal run sql file
SQL
1 vote126 views2 answers
Postgres cast as decimal
SQL
5 votes130 views1 answer
Ignore duplicate rows in sqlite
SQL
1 vote128 views1 answer
Oracle lowercase
SQL