# Database Subscriber: Query

**URL:** <https://forum.alumio.com/t/database-subscriber-query/399>\
**Category:** Outgoing Configuration\
**Created:** [January 19, 2023, 4:08pm UTC](https://forum.alumio.com/t/database-subscriber-query/399 "2023-01-19T16:08:41Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![abubakar](https://forum.alumio.com/letter_avatar_proxy/v4/letter/a/8491ac/32.png) [@abubakar](https://forum.alumio.com/u/abubakar)\
**Post date:** [January 19, 2023, 4:08pm UTC](https://forum.alumio.com/t/database-subscriber-query/399/1 "2023-01-19T16:08:41Z")

</div>

Hello guys,  
I will love to know if the database subscriber only allow “SELECT” in the query textarea because i will like to also INSERT, UPDATE, ALTER etc…

---

<div class="post-metadata">

**Author:** ![Alumio\_Bot](https://forum.alumio.com/user_avatar/forum.alumio.com/alumio_bot/32/1824_2.png) [@Alumio\_Bot](https://forum.alumio.com/u/Alumio_Bot)\
**Post date:** [January 19, 2023, 4:41pm UTC](https://forum.alumio.com/t/database-subscriber-query/399/2 "2023-01-19T16:41:56Z")

</div>

Hi,  
I know we currently atleast support inserting and updating you can read it [here](https://forum.alumio.com/t/how-to-use-a-database-publisher-insert-data-in-database/270).

And I believe the function to delete rows using a publisher is also already finished.  
@Gugi Do you know if deleting using a database publisher has already been released?

Also keep in mind to follow the Alumio flow, Incoming (subscribers) to retrieve data, and outgoing (publishers) to send data.  
In your case, the update and insert queries will need to be created using an outgoing configuration.

---

<div class="post-metadata">

**Author:** ![abubakar](https://forum.alumio.com/letter_avatar_proxy/v4/letter/a/8491ac/32.png) [@abubakar](https://forum.alumio.com/u/abubakar)\
**Post date:** [January 19, 2023, 5:35pm UTC](https://forum.alumio.com/t/database-subscriber-query/399/3 "2023-01-19T17:35:26Z")

</div>

i understand this now,

I don’t know if show tables also exist

---

<div class="post-metadata">

**Author:** ![Alumio\_Bot](https://forum.alumio.com/user_avatar/forum.alumio.com/alumio_bot/32/1824_2.png) [@Alumio\_Bot](https://forum.alumio.com/u/Alumio_Bot)\
**Post date:** [January 19, 2023, 5:51pm UTC](https://forum.alumio.com/t/database-subscriber-query/399/4 "2023-01-19T17:51:21Z")

</div>

Excelent.  
Maybe there’s an sql query that’ll work with the database subscriber to retrieve the tables but that’d be useless in Alumio.  
Because any architectural changes to the database should not be made with Alumio, but with your administration software of choice (phpMyAdmin).

---

<div class="post-metadata">

**Author:** ![abubakar](https://forum.alumio.com/letter_avatar_proxy/v4/letter/a/8491ac/32.png) [@abubakar](https://forum.alumio.com/u/abubakar)\
**Post date:** [January 19, 2023, 6:34pm UTC](https://forum.alumio.com/t/database-subscriber-query/399/5 "2023-01-19T18:34:02Z")

</div>

Thanks @Alumio_Bot this is helpful