UNSOLVED Change group ID number?
So I made 2 groups, deleted them, and now the numbering order starts at 3.
is there an easy way to switch the number counter back to 1?
Wayne Workman last edited by
@vince-villarreal Try to add a group and see what the ID is.
Tom Elliott last edited by
@vince-villarreal I’ll ad \G should not be used with ;, for example:
alter table fog.groups auto_increment = 1\G;is trying to run two separate queries, one for the alter table and one that is blank, hence the error no query message.
\G is a means to display columns in a vertical format where ; will show each row horizontally.
@wayne-workman so I type in console:
ALTER TABLE groups AUTO_INCREMENT = 1;
Then i try it with the \G command at the end (\G = send command to mysql server)
it throws back:
Query OK, 0 rows affected
Records: 0 Duplicates: 0 Warnings: 0
ERROR: No query specified
so I am a noob, where do I type that in at? (tried in mysql)
Wayne Workman last edited by Wayne Workman
@vince-villarreal If you have no groups at all, this will work:
ALTER TABLE groups AUTO_INCREMENT = 1;but if you have any groups at all, this will probably break stuff.