/SQL/How to define a save method in ruby for sqlite3 databases

How to define a save method in ruby for sqlite3 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

20 votes186 views2 answers
Counting in sql
SQL
0 vote187 views1 answer
Stuff in sql server
SQL
0 vote230 views1 answer
Sparql if bound query
SQL
1 vote214 views3 answers
Mysql on delete set null
SQL
0 vote286 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote196 views1 answer
Mysql beautifier terminla
SQL
14 votes234 views3 answers
SQL trim
SQL
16 votes213 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote180 views1 answer
Login to database mysql terminal
SQL
0 vote191 views1 answer
Oracle NLS_CHARACTERSET
SQL