/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 vote102 views1 answer
Mysql events not work
SQL
16 votes104 views2 answers
Add column if not exists mysql
SQL
29 votes95 views5 answers
Mysql show table structure
SQL
0 vote101 views1 answer
Can't connect to postgresql mac os
SQL
1 vote111 views1 answer
Mysql is odd
SQL
2 votes112 views1 answer
Where clause for child record apex
SQL
0 vote94 views1 answer
What is between keyword used for
SQL
0 vote101 views2 answers
Update information in a mysql column
SQL
0 vote96 views1 answer
Order by monthly in sql
SQL
0 vote110 views1 answer
Sqlalchemy one column of two has to be not null
SQL