Title: execute multiple statements at once
Last modified: September 1, 2022

---

# execute multiple statements at once

 *  [Leslie Carson](https://wordpress.org/support/users/lunabug/)
 * (@lunabug)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/execute-multiple-statements-at-once/)
 * Is there a way to execute multiple statements at one time? I’ve tried using just
   the following and although it says success the fields are not updated.
 *     ```
       UPDATE mfp_options SET option_value = 'email@domain.com' WHERE option_name = 'admin_email';
       UPDATE mfp_options SET option_value = 'm/d/Y' WHERE option_name = 'date_format';
       UPDATE mfp_options SET option_value = '/%postname%/' WHERE option_name = 'permalink_structure';
       UPDATE mfp_options SET option_value = 'America/New_York' WHERE option_name = 'timezone_string';
       UPDATE mfp_options SET option_value = '0' WHERE option_name = 'uploads_use_yearmonth_folders';
       ```
   
 * Thanks

The topic ‘execute multiple statements at once’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/my-database-admin.svg)
 * [Database My Admin](https://wordpress.org/plugins/my-database-admin/)
 * [Support Threads](https://wordpress.org/support/plugin/my-database-admin/)
 * [Active Topics](https://wordpress.org/support/plugin/my-database-admin/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/my-database-admin/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/my-database-admin/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [Leslie Carson](https://wordpress.org/support/users/lunabug/)
 * Last activity: [3 years, 9 months ago](https://wordpress.org/support/topic/execute-multiple-statements-at-once/)
 * Status: not resolved