/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

3 votes229 views1 answer
Ms sql skip take
SQL
10 votes245 views5 answers
Mysql create user
SQL
4 votes243 views2 answers
Sql server date now
SQL
4 votes732 views1 answer
Oracle show errors
SQL
1 vote227 views1 answer
How to check the mysql version mac
SQL
0 vote238 views1 answer
Mysql undo delete
SQL
42 votes254 views6 answers
Install beautifulsoup
SQL
1 vote238 views1 answer
How to select rows with no matching entry in another table?
SQL
4 votes216 views2 answers
How to count items with same name in sql
SQL
0 vote230 views2 answers
Sql if empty then
SQL