/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

5 votes136 views1 answer
Oracle find foreign key dependencies
SQL
1 vote143 views2 answers
Extract weekday from date in sql
SQL
1 vote139 views1 answer
Postgresql round double precision
SQL
2 votes133 views1 answer
Oracle run_duration average
SQL
0 vote144 views1 answer
Use mysql in java program
SQL
0 vote137 views1 answer
Get week day name sql server
SQL
-1 vote142 views1 answer
Can pandas fetch data from sql
SQL
0 vote142 views1 answer
Cast as decimal postgresql
SQL
1 vote166 views1 answer
Postgres power
SQL
0 vote173 views1 answer
Mysql get hour from datetime
SQL