/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

9 votes196 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote165 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote170 views1 answer
Group_concat only returns one row
SQL
5 votes185 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote182 views1 answer
Case insensitive sql
SQL
0 vote180 views1 answer
Modificar tipo de dato sql server
SQL
5 votes169 views4 answers
Select random rows sql
SQL
3 votes198 views1 answer
Oracle show trigger code
SQL
0 vote186 views2 answers
Close external port 3306 with iptables
SQL
-1 vote196 views1 answer
Auto increment psql not primary key
SQL