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]> sa
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".
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 n
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 col
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
Mysql says that in the join there are some columns with namer datestamp so you have to
choose by which you want to order.
Think about making LEFT JOIN.
select * from f1 LEFT JOIN f2 ON f1.some_field=f2.some_field LEFT JOIN f3 ON
f2.some_field=f3.some_field roder by f1.datestamp;
Regards,
Andrey
