Title: Import into table using SQL via Webpage
Last modified: February 6, 2024

---

# Import into table using SQL via Webpage

 *  Resolved [sagolfer](https://wordpress.org/support/users/sagolfer/)
 * (@sagolfer)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/import-into-table-using-sql-via-webpage/)
 * 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 participants for an event. But I would
   like to clear the table for all participants first for this event before importing
   the new participants.. The do an update of a value afterwards.
 * 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:
 * DELETE from g_tour_entries where tour_id = ‘2024-01’;
 * 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′);
 * update g_tour_entries set tour_handcap = ‘1’ where tour_id = ‘2024-04’;
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fimport-into-table-using-sql-via-webpage%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/import-into-table-using-sql-via-webpage/#post-17405652)
 * Hi [@sagolfer](https://wordpress.org/support/users/sagolfer/),
 * 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. 🙏

Viewing 1 replies (of 1 total)

The topic ‘Import into table using SQL via Webpage’ 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/)

 * 1 reply
 * 2 participants
 * Last reply from: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [2 years, 4 months ago](https://wordpress.org/support/topic/import-into-table-using-sql-via-webpage/#post-17405652)
 * Status: resolved