/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 vote319 views1 answer
Mysql percentage of total
SQL
1 vote360 views1 answer
Load mysql dumb
SQL
2 votes333 views1 answer
Sqlite indexes
SQL
6 votes348 views3 answers
Commit in sql
SQL
0 vote410 views1 answer
Generate sql from specific migration ef core
SQL
0 vote322 views1 answer
Show function mysql
SQL
1 vote370 views1 answer
Update substring in mysql
SQL
0 vote341 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote384 views1 answer
Sql select without column name
SQL
2 votes319 views1 answer
Mysql sysdate
SQL