/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 vote208 views1 answer
Postgres set sequence value to max id
SQL
11 votes205 views2 answers
You are using safe update mode
SQL
0 vote155 views2 answers
MySQL top percent
SQL
5 votes163 views1 answer
Oracle asynchronous update
SQL
1 vote159 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote133 views1 answer
Lister les index d'une table oracle
SQL
2 votes148 views1 answer
Cast string to datetime mysql
SQL
0 vote157 views1 answer
List all indexes postgres
SQL
0 vote148 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote148 views1 answer
Top frequency in sql server
SQL