/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 vote126 views2 answers
How to install psql in ubuntu
SQL
0 vote118 views1 answer
Drop unique
SQL
0 vote117 views1 answer
Sql script to remove default from column
SQL
0 vote117 views1 answer
Mysql filter based on datediff
SQL
0 vote113 views1 answer
How to find sql server name
SQL
0 vote122 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote152 views1 answer
T-sql delete view if exists
SQL
0 vote115 views1 answer
Allow external access to mysql
SQL
11 votes110 views1 answer
Sql query to find duplicates in column
SQL
8 votes109 views2 answers
Update sql server from another table
SQL