If you created a table using an SQL query, and deleted the data from that table from within the database, it cannot be displayed in the table, since it doesn’t exist anymore. Have you refreshed the page where the table is displayed in the plugin?

Unfortunately, MySQL-query based tables support is not included in the Lite version of the plugin, so if you have any further questions about this feature, please open a ticket on our official support platform, and one of our support managers will gladly help you there.