nuimk unique nuo email lauko.

Nymo wrote:
> 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?
>>>>
>>>>
>>>
>