Tema: Re: Beda su MySQL INSERT
Autorius: Faktas
Data: 2009-07-27 14:07:17
o kokie raktai nurodyti?

 
"Nymo" <nymo.dar@gmail.com> wrote in message news:h4jvkd$sug$1@trimpas.omnitel.net...
> 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?
>>
>> 
>