[rlug] Re: mysql insert (newbie e putin spus)

[Florin Andrei]

On Wed, 2002-02-06 at 05:45, 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

Cimpurile auto-incrementate nu trebuie specificate in INSERT.

Apropo, fa cum a zis Dizzy, cu INSERT INTO tabel (col1, col2...) VALUES
(val1, val2). E mai bine daca specifici explicit numele coloanelor care
trebuie inserate. Si pur si simplu omiti coloanele auto-incrementate
(atit coloana cit si valoarea).

-- 
Florin Andrei

Moshe Bar: "2.4.9 was indeed a very good kernel, but it may not be a
good choice anymore. It is missing a lot of the good features of the
2.4.18pre kernels."
Alan Cox: "And vice versa ;-)"

---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to 
unsubscribe from this list.