Title: Update table using SQL or CSV
Last modified: February 16, 2024

---

# Update table using SQL or CSV

 *  Resolved [sagolfer](https://wordpress.org/support/users/sagolfer/)
 * (@sagolfer)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/update-table-using-sql-or-csv/)
 *     ```wp-block-code
       I have create a page with a ‘wpdadiehard’ shortcode.
   
       I have create the project and page with “Bulk actions allowed” and “Import allowed”.
   
       If , on my page, page_id=4749 , I cliked on import, I get the prompt for import, I chose the file, which is an SQL file, and press “import”.
   
       It import no rows.
   
       What I am trying to accoplish is to import new participants for an event. 
       But I would also like to update a specific field for existing participants 
   
       Is this possible from a Front_end WordPress Page without having to log into the Admin pages?
   
       I nee a easy way to update participants of an event
   
       Examle SQL:
       Update existing participants :
   
       update g_tour_entries set tour_handcap = ‘1’ where tour_id = ‘2024-04’;
   
       Inserting new participants :
   
       INSERT INTO g_tour_entries( tour_entry_id,member_id, tour_id,tour_handicap, golf, meal, raffel, tour_tee,flight_pos,flight_nr,team_id,start_time,2_pot,game_id,reserved) Values (‘2024-01-395′,’395′,’2024-01′,(get_handicap(395)),’1′,’Kabeljauw’,”,’LT’,’2′,’Flight01′,”,’16:00′,”,”,’0′);
       INSERT INTO g_tour_entries( tour_entry_id,member_id, tour_id,tour_handicap, golf, meal, raffel, tour_tee,flight_pos,flight_nr,team_id,start_time,2_pot,game_id,reserved) Values (‘2024-01-523′,’523′,’2024-01′,(get_handicap(523)),’1′,”,”,’M’,’3′,’Flight03′,”,’16:00′,”,”,’0′);
       ```
   
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fupdate-table-using-sql-or-csv%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/update-table-using-sql-or-csv/#post-17437509)
 * Hi [@sagolfer](https://wordpress.org/support/users/sagolfer/),
 * We responded to your previous post about this [here](https://wordpress.org/support/topic/import-into-table-using-sql-via-webpage/).
   Please see our reply below for your convenience:
 * > It’s currently not possible to clear out a table on the front end. 😔
   > You need to log in and be a user with administrator privileges to access the
   > main WP Data Access plugin page and clear a database table.
   > Let us know if you have other questions. 🙏
 * Please let us know if you have additional questions.
 *  Thread Starter [sagolfer](https://wordpress.org/support/users/sagolfer/)
 * (@sagolfer)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/update-table-using-sql-or-csv/#post-17437683)
 * my question id NOT about “ clear out a table on the front end. “
 * it is about inserting and updating
 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/update-table-using-sql-or-csv/#post-17438249)
 * Hi [@sagolfer](https://wordpress.org/support/users/sagolfer/),
 * Apologies for the confusion. It’s the same with importation.
 * You may be able to do updates per row but you cannot do a mass insert/update 
   on the front-end. Only on the backend and as an administrator.
 * This is mainly for security purposes.
 * We appreciate your understanding. 🙏

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Update table using SQL or CSV’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [update](https://wordpress.org/support/topic-tag/update/)

 * 3 replies
 * 2 participants
 * Last reply from: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [2 years, 3 months ago](https://wordpress.org/support/topic/update-table-using-sql-or-csv/#post-17438249)
 * Status: resolved