/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 vote252 views1 answer
SQL Query to delete all the tables in a database
SQL
5 votes260 views4 answers
Rollback to in sql
SQL
0 vote270 views1 answer
MySQL update with subquery
SQL
19 votes257 views6 answers
What is mySQL
SQL
3 votes268 views3 answers
Order by postgres
SQL
42 votes338 views6 answers
Rename table sql server
SQL
2 votes257 views1 answer
Query any digits record
SQL
2 votes225 views1 answer
Latest record in sql
SQL
0 vote245 views1 answer
Mysql workbench procedure
SQL
0 vote245 views1 answer
Create a PostgreSQL user django on mac
SQL