/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

0 vote175 views1 answer
Mysql grant grant option
SQL
6 votes223 views3 answers
Mysql remove user privileges
SQL
0 vote226 views1 answer
Mysql sum per week
SQL
8 votes174 views3 answers
Connect python to mysql
SQL
0 vote196 views1 answer
Oracle chain step succeeded
SQL
0 vote181 views1 answer
Create bdd mysql
SQL
1 vote381 views1 answer
Foreign key in oracle sql developer
SQL
0 vote180 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote187 views1 answer
On delete set default
SQL
2 votes174 views1 answer
Drop all database tables oracle sql developer
SQL