/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

1 vote263 views1 answer
Sql select where id not exists in another table
SQL
5 votes327 views1 answer
Oracle source query
SQL
0 vote234 views1 answer
Oracle list all stored procedures
SQL
0 vote258 views2 answers
Select limit ms sql
SQL
0 vote314 views1 answer
Mysql convert charset
SQL
0 vote310 views1 answer
Declare or use variable in snowflake
SQL
0 vote294 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote275 views1 answer
Sql insert from excel
SQL
0 vote289 views1 answer
Oracle drop type
SQL
1 vote289 views2 answers
Foreign key set 0
SQL