Egor Egorov wrote:
fr0g <[EMAIL PROTECTED]> wrote:
Well I'm in despare.
I have a record in my DB with name=Michalis and surname=Ka*l*ogiannis.
When I try to add name=Michalis and surname=Ka*k*ogiannis I get the
error about duplicates.
It doesn't give an error in the english fi
Well I'm in despare.
I have a record in my DB with name=Michalis and surname=Ka*l*ogiannis.
When I try to add name=Michalis and surname=Ka*k*ogiannis I get the
error about duplicates.
It doesn't give an error in the english field, but it does in greek
fields (with greek characters) even though K
Scott Haneda wrote:
on 05/28/2004 12:31 AM, fr0g at [EMAIL PROTECTED] wrote:
I don't see how this mail helps me.
I still don't know why it sais I have a duplicate record and still don't
know how to correct this.
Those were nice stories, but not really helpfull.
In my table eve
d duplicates is to define as unique the pair
of name & surname.
Are there any ideas why I get this duplicate error?
Robert J Taylor wrote:
fr0g wrote:
Good evening all.
I'm facing a problem with a specific table and the uniques that it has.
I have a table, hosting data of peoples names.
Good evening all.
I'm facing a problem with a specific table and the uniques that it has.
I have a table, hosting data of peoples names.
Some of it's columns are, name_english, surname_english, name_original,
surname_original, name_greek, surname_greek.
I have as unique each combination of columns
Did u choose a database before that?
Martin Hampl wrote:
Hi,
I just installed version 4.1.1 on Mac OS X.
If I enter 'show tables;' after starting mysqld_safe it just says
ERROR:
No query specified
The same happens if I try 'CREATE DATABASE menagerie;'
Why?
Thanks,
Martin.
--
MySQL General
ing to lock the table while you
check for existance - not recommended) or add another column that
contains a unique hash (a bit quicker in terms of database operations,
but probably not as nice as the DB-side solution).
Hope this helps!
Regards,
Chris
fr0g wrote:
I have a table with peo
I have a table with peoples names in 3 different languages.
Fields are like: id, surname_english, name_english, surname_original,
name_original, surname_greek, name_greek.
What I want is to check if a person has been entered twice in that table.
The key is ID but I can't have any other field uniqu