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. WP_Query does not return the result even if the data is present in the database
  29. Change plugin name on WordPress repo
  30. Create a plugin from within WordPress
  31. Class variables not correct on page
  32. Admin AJAX doesn’t work in plugin admin page – Even though code is copied verbatim from WordPress Codex
  33. Are plugins instantiated on every request to WordPress?
  34. Render content of multiple pages and their descendants
  35. Why am I unable to load scripts in head in plugin?
  36. adding a button to the media uploader
  37. Plugin main file is constantly been fired on every website visit
  38. Why WP_Screeen doesn’t show all options with admin_body_class
  39. Always get creating a new table with foreign key
  40. How do I add $_SESSION[”] to my wordpress page?
  41. Plugin Activation Error – The plugin generated 22 characters of unexpected output during activation
  42. How to use the CSS of the WordPress core in the development of my administration page?
  43. output html on post or page from custom plugin [closed]
  44. Change the number of plugins counted on wp-admin/plugins.php
  45. Search users with custom meta data
  46. WordPress Object Oriented plugin development [closed]
  47. What’s the right way to implement functions in footer.php
  48. Calling a class method instantiated by ajax call in wordpress [closed]
  49. How can i list random author?
  50. Our plugin tags not appearing in WordPress Plugin Repository
  51. How can I create a page as a draft from my plugin?
  52. How to get values from network settings panel?
  53. need to find duplicated meta value in custom filed and view the posts that have the same value
  54. Woocommerce plugin – How to create two versions of the same plugin with slightly different implementation for different users
  55. Getting current user data with MySQL statement
  56. Conditional delete metadata does not works
  57. Error using wordpress functions inside a plugin class
  58. How to Join wp_posts & wp_postmeta table using custom query
  59. Use localized plugin name and description even when the plugin is disabled
  60. Cron: Update four post at Hour
  61. submit two file input fields in the same form
  62. Unexpected character and syntax error on wp-includes/formatting.php [closed]
  63. Error datatable whit ajax
  64. Potential issue that plugin could have when it will be installed on several sites
  65. The function called on the wp head hook becomes null
  66. custom post type get_posts() function not work
  67. Create multiple posts when a custom post is created
  68. Cron task gets removed from the schedule
  69. working code, not working – Plugin Dev
  70. category page multiple products add to cart any plugin available for woocommerce
  71. Cannot view Custom Post Type no matter what I try
  72. “Enable Media Replace” plugin does not update serialized object in WPMeta
  73. One time call to external API in widget
  74. Nested Actions and Filters
  75. How to use information from the database in the front-end?
  76. submit form data to wordpress existing database table using my plugin
  77. Is it possible to change plugin’s Admin Panel Url?
  78. echo plugin results on pages
  79. register_activation_hook doesn’t fire at all
  80. WordPress scheduled event not working
  81. plugin_dir_url(__FILE__) searches parent theme in ACF extension
  82. My ajax request don´t work and return 0
  83. Method for creating many-to-one Relationships between custom posts and a single user?
  84. Prefix of $wpdb does not worked and does not displayed
  85. My plugin can’t see my files
  86. Confusing problem with displaying message recipient metadata
  87. Choose default template for a page with code
  88. trying to create simple plugin to filter categories from all authors
  89. Force download a file within plugin file
  90. Change wp_mail SMTP settings for each E-Mail
  91. Proper Failure of Plugin Activation
  92. Can anyone tell me why I can’t edit a plugin when it is installed without having to re-install?
  93. WordPress Thumbnail add action if no thumbnail
  94. How can I add the custom taxonomy categories to the posts and pages?
  95. Creating fields in the database
  96. Pass strings to plugin function [closed]
  97. Ajax in Plugins: returns the whole page
  98. How to create a page template using custom plugin
  99. WordPress 3,5 and Jquery version
  100. contact form 7 captcha support anyother captcha plugin? [closed]