Most likely the datatype you are using for the id field is tinyint, auto
increment. The tinyint datatype only goes to 127, so once you get to 127, it
tries to assign the same value for the next one. Try changing your id
datatype to int.
HTH
Maureen
Brtosz Matosiuk [EMAIL PROTECTED]
hi
It is trying to insert the value '127' into a key field (or indexed field)
when it already has a record with '127' in that field. You may know it as a
key violation
It means you are trying to insert a record with a duplicate primary key
HTH
Peter
Thanks,
but I want wo JOIN data from three tables and then to order
all data by datestamp.
Can I Do It ?
Thanks,
Rosen
Andrey Hristov wrote in message 071401c17759$f5873c80$0b01a8c0@ANDreY...
Mysql says that in the join there are some columns with namer datestamp so
you have to choose by
It sounds to me like what you're trying to do is APPEND data from three
similarly structured tables into one entity ordered by a column common
to all 3 tables called datestamp. If I'm mistaken, then please ignore
all of the following:
Approach #1 (mysql)
Create a temporary table with the
Thanks,
but I want wo JOIN data from three tables and then to order
all data by datestamp.
There must be more than one column called datestamp, this is why mysql is
telling you it's ambiguous.
So you need to tell it which table's datestamp column you wish to use.
for example your new
