/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 vote131 views1 answer
Store case result sql
SQL
0 vote110 views1 answer
SQL FROM-Klausel
SQL
15 votes113 views4 answers
Pl sql
SQL
1 vote109 views1 answer
Mysql show queries running
SQL
9 votes101 views2 answers
Sql server check table exists
SQL
0 vote114 views1 answer
Mssql last day of month
SQL
-1 vote107 views1 answer
Su: Authentication failure mysql
SQL
0 vote99 views1 answer
Table or view does not exist
SQL
0 vote116 views1 answer
How to locate pg_hba.conf file
SQL
0 vote101 views1 answer
Oracle activate program
SQL