/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 vote315 views1 answer
Mysql_error replacement
SQL
10 votes332 views1 answer
User_dependencies
SQL
25 votes346 views6 answers
Import mysql database command line
SQL
2 votes531 views5 answers
Unique in sql server
SQL
3 votes353 views2 answers
Sql not contains
SQL
0 vote345 views1 answer
Flush user resource mysql
SQL
0 vote351 views1 answer
Mysql disable triggers
SQL
0 vote344 views1 answer
SQL Query to delete all the tables in a database
SQL
1 vote321 views1 answer
Importance of comment in mysql
SQL
3 votes328 views1 answer
Pl sql escape &
SQL