/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 vote397 views1 answer
C# execute transact sql
SQL
0 vote396 views1 answer
Mysql value ends with
SQL
2 votes407 views2 answers
Mysql compare datetime to another datetime
SQL
1 vote375 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote366 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote380 views1 answer
Migration graphql
SQL
0 vote342 views1 answer
How to count with except in psql
SQL
2 votes419 views3 answers
How to replace null values in sql
SQL
2 votes346 views1 answer
Oracle table size
SQL
1 vote371 views1 answer
Mysql get domain from url
SQL