Resetting AUTO_INCREMENT primary key

ALTER TABLE tablename AUTO_INCREMENT = 1

Change 1 to your desired value. for that case prior to execution of this you can sort your table with the primary field and get the highest value.

Related Posts:

  1. How does WordPress handle MySQL row lock errors?
  2. $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
  3. Help With MySQL to WPDB Query Conversion
  4. Creating mySQL procedure with $wpdb
  5. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  6. WordPress plugin creation how to execute .sql in order to insert multiple rows at activation of plugin
  7. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  8. Insert data from .sql file in wordpress plugin
  9. WordPress Backend HA (Automatic failover)
  10. DB Query not working in Plugin
  11. Way to send multiple values for column to MySQL?
  12. WordPress plugin: efficient way to store large data
  13. Plugin generating unexpected output – on WP mysql dump import
  14. Can’t create tables with my plugin
  15. Integrating Custom Database with WordPress
  16. How to display results from a data table with an encrypted user id?
  17. How to get the custom field value using SQL query
  18. Need to know if my approach to designing a geneaology plug-in for wordpress makes sense
  19. I created a plugin with ‘view page’ that uses MYSQL + PHP. When I use wp_insert_post(), it turns everything to HTML
  20. WordPress UPDATE queries on MySQL database stuck
  21. Re-writing MySQl query for execute faster
  22. Create Database Tables on Plugin Activation hook
  23. Linking Plugin Files to WP
  24. how to search through plugin in wordpress cimy-user-extra-fields?
  25. Get all the related data from WordPress DB
  26. How to display blog posts only authored by the administrator
  27. How can I delete the options from DB when the plugin is deleted?
  28. Get plugin_dir_url() from one level deep within plugin
  29. Notify Admins about Plugin Merge
  30. Adding Featured Image in Post List
  31. Why does including a file in theme’s functions.php not work?
  32. OEmbed from Pinterest
  33. Should I use RIPS tool to test my themes and plugins?
  34. Add Top-Level Menu that opens URL
  35. Plugin Functionality Only for Editor and Administrator
  36. Plugin to hide admin menu (vertical menu bar)
  37. Issue with post request to admin-post.php
  38. action-scheduler vs wp-background-processing
  39. Do you clean up your self-written plugins’ at deactivation?
  40. Global matrix for shortcodes/content for every page
  41. How to add class in plugin only for network site?
  42. Plugin Development sqlite or WordPress’ database
  43. How to write a plugin to add users to a mail list
  44. WordPress plugin for activating other plugins
  45. Pulling data from custom plugin settings using PHP shortcode and Javascript
  46. Does WP identify plugin by plugin name or plugin_basename?
  47. AJAX search posts and pages
  48. Combine scripts from all extensions of the plugin when an extension is activated
  49. Modifying Author Link to add Author Meta in URL
  50. Checkbox conflict in my custom plugin admin page
  51. Can a Plugin Override New User Default Role Type
  52. How to let user store a file in plugin directory but not have it get deleted on update?
  53. Great blogs site resources/tutorial for WordPress Developers? [closed]
  54. Plugins ignored a line breaks or tag in the WordPress comment functions
  55. How to make multiple admin pages for one plugin?
  56. Create custom pages with a plugin
  57. Is it possible for a plugin to force reading and writing of uploaded images to a database instead of to a filesystem?
  58. Amazon.com intergration with WordPress?
  59. Change letters for day name
  60. (WordPress 5.8.3) Function.php or a plugin for better performance? [duplicate]
  61. Set Multiple Meta Values as an Array Using dispatch( ‘core/editor’ ).editPost() Call in Gutenberg/JS
  62. Elementor Custom Control: How to get input value?
  63. Minimize and Uglify WordPress Plugin Files
  64. How do I make sure that my plugin only runs on article detail pages?
  65. WordPress API functions not working at AJAX functions.php call
  66. How do I show content from a plugin using the template the site is currently working with?
  67. How to check homepage contain blog post?
  68. Create “new pages” within the admin section of plugin
  69. More gentle way to hook WordPress custom url
  70. Creating a plugin that will display text on every page
  71. Xamp installed local wordpress not allowing to publish or install plugin
  72. How to Call Specific .PHP file on add_submenu_page selection in Plugin Development?
  73. Using sessions or an alternative in a plugin
  74. Correct way to expand custom WordPress plugin functions
  75. Hide content for specific users with id
  76. adding dynamic/multiple slug values in ‘option_none_value’
  77. Update wordpress user roles not working as excepted
  78. is it possible to fetch data from a remote api while admin is writing a new post?
  79. Checkbox field that add a subscription product and change prices of other products in checkout and cart page
  80. Can’t access 3rd party API, code works on local server but not on wordpress
  81. Custom author page for custom role
  82. Dynamical slug on custom post type
  83. Storing Array of values into wordpress options
  84. Using WordPress to create a simple web app (SaaS) [closed]
  85. WordPress Add advertising ads befor and after content with periority [closed]
  86. Why some plugins are including wp-includes/plugin.php file?
  87. Change default url to plugin custom post type
  88. Creating a user ‘add custom field’ section
  89. How can I pass value to function in add_menu_page?
  90. How to show post attachment image
  91. Making a Custom Post Type Publish Loop
  92. How wordpress plugin hooks works? [duplicate]
  93. How to hide a piece of code from a wordpress web page?
  94. How to dispaly post informations (such as titles) in an admin plugin menu page?
  95. Someone Comment 1000 times in a Day in My WordPress Site, What Can i Do
  96. get_option returning a different value from what’s saved
  97. Plugin: Custom menu item problem
  98. Getting warning of Missing argument 2 for wpdb::prepare()
  99. Meta box not displaying on the plugin page
  100. public custom posts not showing in my wordpress plugin