As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2739145
Add new row to an existing table generated from sql query
Closed

Comments

  • Eli started the conversation

    Hi , I would like to know if there is an option to add or edit the data in a table that was generated with sql query?

     

  • [deleted] replied

    Hi Eli

    Thank you for reaching out to us.

    You can enable editing for manual, imported and SQL query based tables. As for SQL Query based tables, if the query is pulling data from multiple database tables, editing will probably not be possible.

    You can simply click on Allow editing on the Editing tab and you will be able to add or delete rows from your table.

    The table from the database needs to have a unique auto-increment column, and that column needs to be selected as the ID column for editing in the Editing tab above the table.

    6480032457.png

    Please note that you can't add any columns to SQL query-based tables.