/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

1 vote141 views1 answer
SQLite order random
SQL
1 vote151 views1 answer
Vagrant mysql downgrade version
SQL
0 vote144 views1 answer
Geopoint from json mysql function
SQL
0 vote139 views1 answer
Sql recherche nom prenom
SQL
7 votes156 views4 answers
Database dump mysql command
SQL
1 vote142 views1 answer
Backup mysql data only
SQL
0 vote149 views1 answer
Count characters of string mysql
SQL
8 votes153 views1 answer
Oracle add datafile to tablespace
SQL
0 vote142 views1 answer
Oracle list datafiles
SQL
0 vote181 views1 answer
Insert into table with only identity column
SQL