/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 vote293 views1 answer
Dump only data
SQL
0 vote295 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote272 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote281 views2 answers
Alter table add multiple columns mysql
SQL
0 vote258 views1 answer
Mysql local password denied
SQL
4 votes295 views3 answers
Sql drop database if exists
SQL
7 votes280 views3 answers
Python and mysql connectivity
SQL
0 vote269 views1 answer
How to open mysql in docker
SQL
0 vote264 views1 answer
Sql combine results from two tables
SQL
0 vote273 views2 answers
How to combine diff colmun value using group by postgres
SQL