# Get the number of rows updated in SQLite?

**URL:** https://discourse.julialang.org/t/get-the-number-of-rows-updated-in-sqlite/78023
**Category:** General Usage
**Tags:** sqlite
**Created:** [March 17, 2022, 12:58pm UTC](https://discourse.julialang.org/t/get-the-number-of-rows-updated-in-sqlite/78023 "2022-03-17T12:58:20Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![taotree](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/taotree/32/31982_2.png) [@taotree](https://discourse.julialang.org/u/taotree)
#### Post date: [March 17, 2022, 12:58pm UTC](https://discourse.julialang.org/t/get-the-number-of-rows-updated-in-sqlite/78023/1 "2022-03-17T12:58:20Z")

</div>

In other languages I’ve used, after running update SQL, it returns the number of rows updated. However, when I run `DBInterface.execute("update Test set val='green' where id=1")`, it seems to return nothing. Is there a way to get the number of rows updated when executing an update statement?

I found that I can run `select changes()` to get it, but is there a way to get it in a single call?