# Run Select query and Insert query inansible

**URL:** <https://forum.ansible.com/t/run-select-query-and-insert-query-inansible/29329>\
**Category:** Ansible Project\
**Created:** [December 26, 2018, 9:33am UTC](https://forum.ansible.com/t/run-select-query-and-insert-query-inansible/29329 "2018-12-26T09:33:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tharindu\_Weerakoon](https://avatars.discourse-cdn.com/v4/letter/t/b4bc9f/32.png) [@Tharindu\_Weerakoon](https://forum.ansible.com/u/Tharindu_Weerakoon)\
**Post date:** [December 26, 2018, 9:33am UTC](https://forum.ansible.com/t/run-select-query-and-insert-query-inansible/29329/1 "2018-12-26T09:33:00Z")

</div>

Hello all,

I have got lot of answers for my previous post. Thanks for everyone.

Could you please help me to insert record to MYSQL db through the playbook.

Tharindu

---

<div class="post-metadata">

**Author:** ![Tharindu\_Weerakoon](https://avatars.discourse-cdn.com/v4/letter/t/b4bc9f/32.png) [@Tharindu\_Weerakoon](https://forum.ansible.com/u/Tharindu_Weerakoon)\
**Post date:** [December 30, 2018, 3:42am UTC](https://forum.ansible.com/t/run-select-query-and-insert-query-inansible/29329/2 "2018-12-30T03:42:52Z")

</div>

Hi anyone can support

---

<div class="post-metadata">

**Author:** ![Kai\_Stian\_Olstad](https://avatars.discourse-cdn.com/v4/letter/k/e19adc/32.png) [@Kai\_Stian\_Olstad](https://forum.ansible.com/u/Kai_Stian_Olstad)\
**Post date:** [December 30, 2018, 8:32am UTC](https://forum.ansible.com/t/run-select-query-and-insert-query-inansible/29329/3 "2018-12-30T08:32:43Z")

</div>

To my knowledge there is no Ansible module to do this.  
So you need to find out how to do that on the command line. Then you have command, shell and script module at you disposal in Ansible.

If you are asking how to do that on the command line you should find the MySQL community and ask there.

---

<div class="post-metadata">

**Author:** ![jbister](https://avatars.discourse-cdn.com/v4/letter/j/7bcc69/32.png) [@jbister](https://forum.ansible.com/u/jbister)\
**Post date:** [December 31, 2018, 7:10pm UTC](https://forum.ansible.com/t/run-select-query-and-insert-query-inansible/29329/4 "2018-12-31T19:10:40Z")

</div>

[https://stackoverflow.com/questions/30605950/running-a-select-query-with-an-ansible-task](https://stackoverflow.com/questions/30605950/running-a-select-query-with-an-ansible-task)