/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

1 vote258 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote269 views1 answer
Running mysql from bash sc
SQL
0 vote254 views2 answers
Sql drop view if exists
SQL
0 vote274 views1 answer
Oracle drop type
SQL
0 vote309 views1 answer
Plpgsql create function
SQL
2 votes252 views2 answers
Mysql limit
SQL
0 vote282 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote236 views1 answer
Sort by last two number sql
SQL
25 votes270 views3 answers
How to use a database to see tables mysql
SQL
4 votes252 views3 answers
Mysql modify foreign key
SQL