Tema: Re: Beda su MySQL INSERT
Autorius: Nymo
Data: 2009-07-27 22:00:36
Raktai tokie:
user_id PRIMARY
email UNIQUE

Ka bendro turetu php, jei as keliu duomenis tiesiai per "phpmyadmin"?
Email lauko duomenis susikele be problemu,o vat card_number nei pro kur!

"Faktas" <Faktas_istrinti_@delfi.lt> wrote in message 
news:h4k1p5$oe$1@trimpas.omnitel.net...
>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?
>>>
>>>
>>