Skip to content

Mike Colbert Online

http://www.mikecolbertonline.com

  • Sample Page
  • Sample Page
  • Risk

Resetting the AUTO_INCREMENT value in MySQL

March 23, 2018 by Mike

How do I remove all data from a table and reset the AUTO_INCREMENT value back to 1?


TRUNCATE database_name.table_name

 

Categories MySQL
Post navigation
Changing AUTO_INCREMENT value in MySQL
Connecting to an Arduino Feather Huzzah and Testing (step 1)
  • Cisco
  • Digital Photo
  • Excel VBA
  • Flask
  • HTML & CSS
  • IoT
  • Java
  • Linux
  • Microsoft Azure
  • Microsoft SQL
  • MySQL
  • Oracle SQL
  • Python
  • Security
  • SQLAlchemy
  • Uncategorized
  • Wordpress
  • April 2020
  • November 2019
  • April 2019
  • December 2018
  • October 2018
  • August 2018
  • July 2018
  • March 2018
  • September 2017
  • March 2017
  • February 2017
  • November 2016
  • October 2016
  • July 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • September 2015
  • June 2015
  • May 2015
  • April 2015
  • January 2015
Log in
Log in
© 2023 Mike Colbert Online • Built with GeneratePress