Skip to content

Instantly share code, notes, and snippets.

@kernusr

kernusr/ai_change.md

Created October 11, 2021 07:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kernusr/1712dfd0c25472d9969eeb2bdc83f928 to your computer and use it in GitHub Desktop.
Save kernusr/1712dfd0c25472d9969eeb2bdc83f928 to your computer and use it in GitHub Desktop.
Download ZIP
Двигаем auto_increment в mysql
Raw
ai_change.md

Посмотреть текущее значение AUTO_INCREMENT

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'db_name'
  AND   TABLE_NAME   = 'table_name';

Поменять текущее значение AUTO_INCREMENT

ALTER TABLE 'table_name' AUTO_INCREMENT = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment