# Import MySQL table

**URL:** <https://forum.inductiveautomation.com/t/import-mysql-table/103838>\
**Category:** Ignition\
**Tags:** database, perspective\
**Created:** [March 18, 2025, 4:15pm UTC](https://forum.inductiveautomation.com/t/import-mysql-table/103838 "2025-03-18T16:15:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![TechEnlive](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@TechEnlive](https://forum.inductiveautomation.com/u/TechEnlive)\
**Post date:** [March 18, 2025, 4:15pm UTC](https://forum.inductiveautomation.com/t/import-mysql-table/103838/1 "2025-03-18T16:15:23Z")

</div>

Hi,  
I am new to ignition perspective. I have create three views and add table to show data.  
i don't know how to import data. Can some one give guide?

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [March 18, 2025, 4:22pm UTC](https://forum.inductiveautomation.com/t/import-mysql-table/103838/2 "2025-03-18T16:22:53Z")

</div>

1. Create a Named Query to retrieve the data from the database. Test it in the Query Editor.
2. Select the Table component.
3. In Perspective Property Browser, click in the left gutter beside `PROPS.data` and create a Query binding.
4. Select your query from the dropdown list. Your table should now populate.

Read the book. Watch the video.

> **[Named Queries | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/platform/sql-in-ignition/named-queries)**
>
> What are Named Queries?