๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
studies/Back-end

[MySQL] autoincrement resetting

by Vada Kim 2021. 1. 6.
728x90
๋ฐ˜์‘ํ˜•

SQLite autoincrement reset

 

UPDATE SQLITE_SEQUENCE SET seq = N WHERE name = 'TABLE_NAME'; 

 

728x90
๋ฐ˜์‘ํ˜•