/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

2 votes158 views1 answer
Sql alchemy or
SQL
10 votes158 views2 answers
Linux command line import mysql database
SQL
0 vote193 views1 answer
C# select Mysql
SQL
1 vote167 views1 answer
Mamp mysql path mac
SQL
0 vote167 views4 answers
Database stuck at restoring state
SQL
0 vote168 views1 answer
Mysql streaming example
SQL
0 vote177 views1 answer
Sql select all records from all tables where not empty
SQL
2 votes179 views1 answer
Oracle percentage
SQL
6 votes214 views2 answers
What is non relational database
SQL
0 vote157 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL