/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

17 votes226 views5 answers
Order by sql
SQL
-2 votes227 views1 answer
Remove root password mysql
SQL
5 votes239 views2 answers
Get number of columns sql
SQL
11 votes230 views4 answers
Round in sql
SQL
0 vote242 views1 answer
QUERY JPQL
SQL
7 votes227 views1 answer
Postgres base size
SQL
1 vote227 views1 answer
Oracle apex prevent initial load
SQL
0 vote229 views1 answer
T-SQL Retry (deadlock)
SQL
6 votes238 views2 answers
What is non relational database
SQL
1 vote229 views1 answer
Mysql select another database
SQL