/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 vote184 views1 answer
Microsoft word insert sql code
SQL
2 votes192 views1 answer
Username sql
SQL
3 votes147 views1 answer
How to get list of synonyms in oracle
SQL
0 vote191 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote194 views1 answer
How to find sql server name
SQL
0 vote218 views1 answer
"Hello User Name"
SQL
0 vote192 views1 answer
Psql get table data types
SQL
16 votes230 views1 answer
Sqlserver add column to table
SQL
1 vote191 views1 answer
Oracle create_program
SQL
0 vote199 views1 answer
Postgresql on conflict pair
SQL