Codice dei programmi nella directory:<br><pre><code style="color: #000000"><span style="color: #0000BB"><hr><b>///File: TestAutoIncrement.txt</b><br>
L</span><span style="color: #DD0000">'autoincrement NON recupera i "buchi" di codice.
Nel seguente esercizio al campo pippo con value '</span><span style="color: #0000BB">paperino</span><span style="color: #DD0000">' viene assegnato il valore 4

comunque e' </span><span style="color: #0000BB">possibile forzare il valore mancante </span><span style="color: #007700">(</span><span style="color: #0000BB">o buco</span><span style="color: #007700">, </span><span style="color: #0000BB">perso</span><span style="color: #007700">) </span><span style="color: #0000BB">con un</span><span style="color: #DD0000">'INSERT del tipo:
INSERT INTO teste_aut_inc (id, pippo) VALUES (3, '</span><span style="color: #0000BB">paperino</span><span style="color: #DD0000">');

Prova in Postgresql
____________________


create table teste_aut_inc (
id SERIAL primary key,
pippo varchar(10)
);

insert into teste_aut_inc (pippo) values ('</span><span style="color: #0000BB">ciao</span><span style="color: #DD0000">');
insert into teste_aut_inc (pippo) values ('</span><span style="color: #0000BB">cia</span><span style="color: #DD0000">');
insert into teste_aut_inc (pippo) values ('</span><span style="color: #0000BB">ci</span><span style="color: #DD0000">');*/

select * from teste_aut_inc

delete from teste_aut_inc where id = 3;

insert into teste_aut_inc (pippo) values ('</span><span style="color: #0000BB">paperino</span><span style="color: #DD0000">'); -- qui viene inserito l'</span><span style="color: #0000BB">id a 4
<br>///(Fine file: TestAutoIncrement.txt)
</span></code></pre>