/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 vote361 views1 answer
Cross apply top for each row t1
SQL
8 votes393 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote349 views1 answer
How to open mysql in docker
SQL
2 votes339 views1 answer
Mysql find tables with name
SQL
2 votes363 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
-1 vote401 views4 answers
Full outer join in sql
SQL
0 vote349 views1 answer
Mysql use password error
SQL
0 vote368 views1 answer
Mysql get date diff in months
SQL
0 vote356 views1 answer
Sqlite to csv statement
SQL
0 vote406 views1 answer
Sql server synonym
SQL