Tema: Re: Beda su MySQL INSERT
Autorius: Nymo
Data: 2009-07-27 13:30:38
Jei bandau naudoti pasiulyta istraiska, i baze iraso tik pati pirma irasa. 
Jei naudoju israiska be IGNORE tada ismeta  #1062 - Duplicate entry '' for 
key 2
po sito yra mygtukas placiau, ji paspaudus, atidaro toki pranesima:

Klaida
SQL užklausa:

SELECT *
FROM Array
WHERE CONCAT_WS( "-", card_number ) = ""
ORDER BY card_number
LIMIT 0 , 30

MySQL atsakymas:

#1146 - Table 'zana.Array' doesn't exist


Kaip visa tai suprasti?


"scrp" <d@b.z> wrote in message news:h4hqeq$vgd$1@trimpas.omnitel.net...
> INSERT IGNORE INTO users (card_number)
> VALUES ('1111'), ('1112'), ('1113'), ('1111).....
>
>
> "Nymo" <nymo.dar@gmail.com> wrote in message 
> news:h4hdv0$lkc$1@trimpas.omnitel.net...
>> Yra daugiau kaip 2000 irasu, bandau juos iterpti naudodamas tokia 
>> israiska:
>> INSERT INTO users (card_number) VALUES ( 789995431 ) ;
>> (789995432 );
>> .....;
>> (7789987478);
>> Ismeta tokia klaida:
>> #1062 - Duplicate entry '' for key 2
>> kai bandau iterpti 1 irasa,viskas gerai. Kas cia gali buti negerai?
>
>