daca restul variabilelor sunt autoincrement, atunci faci asa:
insert into tabla values('9',NULL,NULL,NULL,NULL,NULL)
ca idee generala, in tabele in care ai variabile autoincrement, pui NULL
in dreptul lor si atunci se incrementeaza.
Eugen
On Wed, Feb 06, 2002 at 03:45:27PM +0200, Razvan Cosma wrote:
> Incerc sa introduc o linie intr-o tabla cu index autoincrement ceva de
> genul:
> insert into tabla values ('9','','','','','');
> unde prima value e indexul, in speranta ca restul vor fi incrementate
> corespunzator. Rezultatul este:
> ERROR 1062: Duplicate entry '9' for key 1
> Este vreo metoda rapida in genul a ce am incercat eu, sau trebuie sa
> "select pina la noua from into foo, insert into foo, select de la 9
> incolo into foo, drop tabla" etc?
> Multumesc
>
>
>
> ---
> Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
> unsubscribe from this list.
>
---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
unsubscribe from this list.
