Tuesday, October 8, 2013

mengatasi error Duplicate entry '1' for key 1

misal perintah sql :
INSERT INTO mobiware2 (idkw, kw) VALUES
(1, ' how to turn off facebook contacts on a samsung galaxy 3'),

padahal di table sudah terdapat idkw 1 maka error  error Duplicate entry '1' for key 1 akan muncul

cara mengatasi :
INSERT INTO mobiware2 (idkw, kw) VALUES
(null, ' how to turn off facebook contacts on a samsung galaxy 3'),

null akan menjadi id secara otomatis di idkw paling ahir alias auto increment.

No comments:

Post a Comment