Ej 3.5.3 Valores de Autoincremento | Comandos DML: Manipulación de datos con MySQL

CREATE TABLE TAB_IDENTITY2 (ID INT AUTO_INCREMENT, DESCRIPTOR VARCHAR(20), PRIMARY KEY(ID));
INSERT INTO TAB_IDENTITY2 (DESCRIPTOR) VALUES ('CLIENTE1');
INSERT INTO TAB_IDENTITY2 (DESCRIPTOR) VALUES ('CLIENTE2');
INSERT INTO TAB_IDENTITY2 (DESCRIPTOR) VALUES ('CLIENTE3');
INSERT INTO TAB_IDENTITY2 (ID, DESCRIPTOR) VALUES (NULL, 'CLIENTE4');
DELETE FROM TAB_IDENTITY2 WHERE ID = 3;
INSERT INTO TAB_IDENTITY2 (ID, DESCRIPTOR) VALUES (NULL, 'CLIENTE6');
INSERT INTO TAB_IDENTITY2 (ID, DESCRIPTOR) VALUES (NULL, 'CLIENTE7');
DELETE FROM TAB_IDENTITY2 WHERE ID = 2;

select * from tab_identity2;

El ultimo ID generado es 6

CREATE TABLE TAB_IDENTITY2 (ID INT AUTO_INCREMENT, DESCRIPTOR VARCHAR(20), PRIMARY KEY(ID)); INSERT INTO TAB_IDENTITY2 (DESCRIPTOR) VALUES ('CLIENTE1'); INSERT INTO TAB_IDENTITY2 (DESCRIPTOR) VALUES ('CLIENTE2'); INSERT INTO TAB_IDENTITY2 (DESCRIPTOR) VALUES ('CLIENTE3'); INSERT INTO TAB_IDENTITY2 (ID, DESCRIPTOR) VALUES (NULL, 'CLIENTE4'); DELETE FROM TAB_IDENTITY2 WHERE ID = 3; INSERT INTO TAB_IDENTITY2 (ID, DESCRIPTOR) VALUES (NULL, 'CLIENTE6'); INSERT INTO TAB_IDENTITY2 (ID, DESCRIPTOR) VALUES (NULL, 'CLIENTE7'); DELETE FROM TAB_IDENTITY2 WHERE ID = 2; select * from tab_identity2;