This is perfectly legal and right. A null should not be used for a
value, and null should be used where a value will be put but has not
been yet, so if I plan on putting 3 entries in where they are all the
same but that in future will be different this is correct. Anyways two
NULLS should not b
At 03:30 PM 8/28/2003, you wrote:
In the last episode (Aug 28), mos said:
> Example. Join_Time is usually NULL (but not always). I've discovered that
> if Join_Time is NULL, MySQL allows for duplicate rows! !
>
> Data:
> Cust_Type, Area, Join_Date, Join_Time
> 'BIG', 'N', '2003-01-01',NULL
> 'BIG',
In the last episode (Aug 28), mos said:
> Example. Join_Time is usually NULL (but not always). I've discovered that
> if Join_Time is NULL, MySQL allows for duplicate rows! !
>
> Data:
> Cust_Type, Area, Join_Date, Join_Time
> 'BIG', 'N', '2003-01-01',NULL
> 'BIG', 'N', '2003-01-01',NULL
> 'BIG',
I have a table with a UNIQUE compound index, Cust_Primary that is composed
of 4 columns: Cust_Type, Area, Join_Date, Join_Time.
This index should allow for only unique entries, but it doesn't. If
Join_Time is NULL then it allows for duplicates. Why?
CREATE TABLE `CustHistory2` (
`Cust_Id` int(
> > No, the last inserted id is just 1051 or something like that.
> > Must be something else.
> > Dunno where '2147483647' comes from.
> >
> > Is there a way to reset the auto_increment value or something?
> >
> First, check out with myisamchk if the table isn't crashed.
> Then you can use SET INS
Dnia Thu, 27 Feb 2003 11:22:57 +0100
"Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]> zeznał/a co następuje:
> Hello
>
> Have anyone got this error before:
> ERROR 1062: Duplicate entry '2147483647' for key 1
>
> I get it when I do a simple insert query. The primary key is an
> auto_increment f
Hello
Have anyone got this error before:
ERROR 1062: Duplicate entry '2147483647' for key 1
I get it when I do a simple insert query. The primary key is an
auto_increment field and are not specified in the insert.
Thanks,
Jonas
-
002 11:20 AM
> To: mysql
> Cc: oswaldo
> Subject: Duplicate Keys
>
>
> Hi List
>
> Sorry for the newbie question.
>
> Im new to MySQL. I have a table that I don't know how many
> duplicate records
> it has, so how do I query and delete all the duplica
Hi,
Try ALTER IGNORE TABLE your_table ADD UNIQUE
(column_where_you_dont_want_duplicates);
Regards,
Jocelyn Fournier
- Original Message -
From: "Oswaldo Castro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 26, 2002 8:20 PM
Subject: Dupl
Hi List
Sorry for the newbie question.
Im new to MySQL. I have a table that I don't know how many duplicate records
it has, so how do I query and delete all the duplicate (or many multiple)
records from a MySQL table ?
Thanks in advance
Oswaldo Castro
---
Hi,
I'm getting Duplicate Keys errors from mysql when i have more than one
application attempting to insert into a table. I've tried using LOCK TABLES
to no avail.
Can anyone describe how the Duplicate Keys error occurs so I can understand
how to code around it ?
regards,
Graeme W
he PRIMARY KEY field. When you attempt to insert the
next key with 300, that is an error.
-Original Message-
From: mweb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 1:16 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: What is causing duplicate keys?
Hello,
Always str
Hello,
Always struggling on my php-odbc-MS access project, I managed to successfully
add a record to a table.
Now, no matter what I write in the first field (random numbers, AUTO,
AUTO_INCREMENT...)
I get this:
Insert Into recensioni VALUES (300, 'riee', 'reworew', 'wer', 2001,'IT', 2.5,
'd
13 matches
Mail list logo