# SQLite.jl execute with "pragma" not working

**URL:** https://discourse.julialang.org/t/sqlite-jl-execute-with-pragma-not-working/46935
**Category:** New to Julia
**Tags:** sqlite
**Created:** [September 19, 2020, 8:45pm UTC](https://discourse.julialang.org/t/sqlite-jl-execute-with-pragma-not-working/46935 "2020-09-19T20:45:40Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![andrey2185](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/andrey2185/32/9889_2.png) [@andrey2185](https://discourse.julialang.org/u/andrey2185)
#### Post date: [September 19, 2020, 8:45pm UTC](https://discourse.julialang.org/t/sqlite-jl-execute-with-pragma-not-working/46935/1 "2020-09-19T20:45:40Z")

</div>

Hello, why this not working?

I do

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

```

but then count\_changes=false in my database

---

<div class="post-metadata">

### Author: ![andrey2185](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/andrey2185/32/9889_2.png) [@andrey2185](https://discourse.julialang.org/u/andrey2185)
#### Post date: [September 19, 2020, 10:04pm UTC](https://discourse.julialang.org/t/sqlite-jl-execute-with-pragma-not-working/46935/2 "2020-09-19T22:04:12Z")

</div>

work for the current session