/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 vote145 views1 answer
Create table split string function in sql server
SQL
0 vote150 views1 answer
How to find total working hour in sql
SQL
0 vote167 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote174 views1 answer
Reindexing all tables sql server
SQL
9 votes149 views1 answer
Identity insert on sql server
SQL
5 votes210 views1 answer
Oracle source query
SQL
0 vote142 views1 answer
Drop CHECK constraint sql
SQL
1 vote165 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote136 views1 answer
Oracle character index
SQL
16 votes143 views2 answers
Oracle ddl
SQL