/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 vote244 views1 answer
Mysql default uuid
SQL
0 vote199 views1 answer
Nvl2 syntax
SQL
0 vote178 views2 answers
Get top 1 row of each group
SQL
8 votes274 views2 answers
Change name of colum in sql table
SQL
1 vote189 views3 answers
Mysql disable foreign keys check
SQL
1 vote203 views1 answer
Mysql show data from table
SQL
0 vote196 views1 answer
Get primary key of table
SQL
0 vote175 views1 answer
Mariadb set vertical output format
SQL
2 votes218 views1 answer
Column names in oracle sql
SQL
1 vote188 views1 answer
How to run sql script
SQL