/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

3 votes189 views2 answers
Postgresql remove not null constraint
SQL
1 vote146 views1 answer
Alter user mysql native password
SQL
8 votes183 views1 answer
Unique vs primary key
SQL
0 vote191 views1 answer
How to move a columns location in mysql
SQL
0 vote192 views1 answer
Pip install mysqlclient error
SQL
0 vote189 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote185 views1 answer
Enable full text search mysql
SQL
1 vote209 views5 answers
Sql 2nd highest salary
SQL
2 votes225 views1 answer
Dbms transaction (psql)
SQL
0 vote201 views1 answer
Oracle list subpartitions
SQL