Question about Name Queries

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.

Testing Table

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

1 Like

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

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?

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