Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
This is possible in two steps by using a dynamic SQL: SET @nextId = (SELECT MAX(id) + 1 FROM `CustomTable` ); SET @sql = CONCAT('ALTER TABLE `CustomTable` AUTO_INCREMENT = ', @nextId[]()); PREPA...
Answer
#4: Post edited
by
Alexei
·
2020-11-15T21:48:21Z (about 4 years ago)
fixed a typo
This is possible in two steps and[]() [using a dynamic SQL](https://stackoverflow.com/questions/46622690/set-auto-increment-value-through-variable-in-mysql):- SET @nextId = (SELECT MAX(id) + 1 FROM `CustomTable` );
- SET @sql = CONCAT('ALTER TABLE `CustomTable` AUTO_INCREMENT = ', @nextId[]());
- PREPARE st FROM @sql;
- EXECUTE st;
- However, if the values fall frequently you should try to find the underlying cause.[]()
- This is possible in two steps by [using a dynamic SQL](https://stackoverflow.com/questions/46622690/set-auto-increment-value-through-variable-in-mysql):
- SET @nextId = (SELECT MAX(id) + 1 FROM `CustomTable` );
- SET @sql = CONCAT('ALTER TABLE `CustomTable` AUTO_INCREMENT = ', @nextId[]());
- PREPARE st FROM @sql;
- EXECUTE st;
- However, if the values fall frequently you should try to find the underlying cause.[]()
#3: Post edited
by
Alexei
·
2020-11-14T06:58:47Z (about 4 years ago)
fixed variable name
- This is possible in two steps and[]() [using a dynamic SQL](https://stackoverflow.com/questions/46622690/set-auto-increment-value-through-variable-in-mysql):
- SET @nextId = (SELECT MAX(id) + 1 FROM `CustomTable` );
SET @sql = CONCAT('ALTER TABLE `CustomTable` AUTO_INCREMENT = ', @max_id);- PREPARE st FROM @sql;
- EXECUTE st;
- However, if the values fall frequently you should try to find the underlying cause.[]()
- This is possible in two steps and[]() [using a dynamic SQL](https://stackoverflow.com/questions/46622690/set-auto-increment-value-through-variable-in-mysql):
- SET @nextId = (SELECT MAX(id) + 1 FROM `CustomTable` );
- SET @sql = CONCAT('ALTER TABLE `CustomTable` AUTO_INCREMENT = ', @nextId[]());
- PREPARE st FROM @sql;
- EXECUTE st;
- However, if the values fall frequently you should try to find the underlying cause.[]()
#2: Post edited
by
Alexei
·
2020-11-14T06:58:11Z (about 4 years ago)
fixed the link
This is possible in two steps and [using a dynamic SQL](https://stackoverflow.com/questions/46622690/set-auto-increment-value-through-variable-in-mysql):- SET @nextId = (SELECT MAX(id) + 1 FROM `CustomTable` );
- SET @sql = CONCAT('ALTER TABLE `CustomTable` AUTO_INCREMENT = ', @max_id);
- PREPARE st FROM @sql;
- EXECUTE st;
However, if the values fall frequently you should try to find the underlying cause.
- This is possible in two steps and[]() [using a dynamic SQL](https://stackoverflow.com/questions/46622690/set-auto-increment-value-through-variable-in-mysql):
- SET @nextId = (SELECT MAX(id) + 1 FROM `CustomTable` );
- SET @sql = CONCAT('ALTER TABLE `CustomTable` AUTO_INCREMENT = ', @max_id);
- PREPARE st FROM @sql;
- EXECUTE st;
- However, if the values fall frequently you should try to find the underlying cause.[]()
#1: Initial revision
by
Alexei
·
2020-11-14T06:57:43Z (about 4 years ago)
This is possible in two steps and [using a dynamic SQL](https://stackoverflow.com/questions/46622690/set-auto-increment-value-through-variable-in-mysql):
SET @nextId = (SELECT MAX(id) + 1 FROM `CustomTable` );
SET @sql = CONCAT('ALTER TABLE `CustomTable` AUTO_INCREMENT = ', @max_id);
PREPARE st FROM @sql;
EXECUTE st;
However, if the values fall frequently you should try to find the underlying cause.