SQLite.jl execute with "pragma" not working

New to Julia
1

Hello, why this not working?

I do

using SQLite
db = SQLite.DB("SQLite_test.db")
SQLite.execute(db, "PRAGMA count_changes=true;")

but then count_changes=false in my database

2

work for the current session