/SQL/How to define a save method in ruby for sql databases

How to define a save method in ruby for sql 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 vote151 views1 answer
What is default mysql database password in linux
SQL
6 votes131 views3 answers
Oracle all dates between two dates
SQL
4 votes127 views2 answers
How to delete row in sql
SQL
0 vote128 views1 answer
Implizite joins sql
SQL
1 vote135 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
3 votes163 views1 answer
Mysql cli connect with password
SQL
40 votes202 views4 answers
PostgreSQL add column
SQL
0 vote126 views1 answer
Sum value by month sql
SQL
36 votes146 views3 answers
Add column in mysq
SQL
-1 vote132 views1 answer
Window functions in sql
SQL