Reset the autoincremention in Libreoffice Base

[BobDe1]

I created a table that would auto_increment a column (RosterID). After a system crash and rebuild, the table (RosterID) went from numbering 6500 to 10000 . I tried Ratslingers fix

alter table “memberpersonalinfo” alter column “RosterID” restart with 6553 Where 6553 = number to restart with

And keep getting this error

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘restart with 6553 Where 6553 = number to restart with’ at line 1

Any Ideas??
Thanks
Bob

[Wanderer]

ALTER TABLE xyz AUTO_INCREMENT = 1;

You may check, if ratslinger used MariaDB or perhaps HSQLDB…

MySQL Resetting the index count to 0

[RobertG]

@BobDe1 : You have used the code for HSQLDB and copied also the comment from Ratslinger into your SQL-command. Have a look at the error. Wrong code begins with 'restart', because you use MariaDB. And 'restart' isn’t known there. And then you added 'WHERE 6553 = number to restart with' - this has been a comment, not a part of the SQL-code.

Have a look at all the help for MariaDB:

AUTO_INCREMENT

[robleyd]

MariaDB: Reset the Next Value in AUTO_INCREMENT column