# Question about Name Queries

**URL:** <https://forum.inductiveautomation.com/t/question-about-name-queries/71444>\
**Category:** Ignition\
**Tags:** ignition81, database\
**Created:** [March 22, 2023, 5:06pm UTC](https://forum.inductiveautomation.com/t/question-about-name-queries/71444 "2023-03-22T17:06:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chang\_Shi](https://avatars.discourse-cdn.com/v4/letter/c/d07c76/32.png) [@Chang\_Shi](https://forum.inductiveautomation.com/u/Chang_Shi)\
**Post date:** [March 22, 2023, 5:06pm UTC](https://forum.inductiveautomation.com/t/question-about-name-queries/71444/1 "2023-03-22T17:06:00Z")

</div>

Could you someone answer my question? I used the name query to create the table in ignition 8.1, It looks like name query only connect SQLite database and show the table. When I use the MySQL connected, Cant see any table in the Table Browser. I attached the screenshot below. I tested the table through Testing Tab. It was no errors.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/5/b59f972e1b971775706eea287633dd8e7ef51323.png)  
 ![Testing Table](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/a/caaf472c5e96eeb5bf5bd01fa0760ce40c426897.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 22, 2023, 5:11pm UTC](https://forum.inductiveautomation.com/t/question-about-name-queries/71444/2 "2023-03-22T17:11:32Z")

</div>

SQLite and MySQL have different syntax. It is very odd to use a named query to perform data definition, fwiw.

---

<div class="post-metadata">

**Author:** ![Chang\_Shi](https://avatars.discourse-cdn.com/v4/letter/c/d07c76/32.png) [@Chang\_Shi](https://forum.inductiveautomation.com/u/Chang_Shi)\
**Post date:** [March 22, 2023, 5:20pm UTC](https://forum.inductiveautomation.com/t/question-about-name-queries/71444/3 "2023-03-22T17:20:08Z")

</div>

so, I can only connect with SQLite when I create the table through name query in Ignition. Is that correct?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 22, 2023, 5:22pm UTC](https://forum.inductiveautomation.com/t/question-about-name-queries/71444/4 "2023-03-22T17:22:36Z")

</div>

You should be able to use MySQL, but your CREATE syntax is likely to be different.

My point, though, is why are you using a **Named Query** for this operation?

---

<div class="post-metadata">

**Author:** ![Chang\_Shi](https://avatars.discourse-cdn.com/v4/letter/c/d07c76/32.png) [@Chang\_Shi](https://forum.inductiveautomation.com/u/Chang_Shi)\
**Post date:** [March 22, 2023, 5:35pm UTC](https://forum.inductiveautomation.com/t/question-about-name-queries/71444/5 "2023-03-22T17:35:21Z")

</div>

thank you. I am learning this session right now and want to test it.