Hi Chris,
On 3/24/2015 10:07 AM, Chris Hornung wrote:
Thanks for the suggestions regarding non-printing characters, definitely
makes sense as a likely culprit!
However, the data really does seem to be identical in this case:
mysql> select id, customer_id, concat('-', group_id, '-') from
app_cu
Thanks for the suggestions regarding non-printing characters, definitely
makes sense as a likely culprit!
However, the data really does seem to be identical in this case:
mysql> select id, customer_id, concat('-', group_id, '-') from
app_customergroupmembership where customer_id ='ajEiQA';
+
Please do
select id, customer_id, concat('-', group_id, '-')
from app_customergroupmembership
where customer_id ='ajEiQA';
I suspect one of those group IDs has a trailing space or similar 'invible'
character that makes it not identical.
- Original Message -
> From: "Chris
Ilham,
It means what it says.You are attempting to insert into a table
that has a primary or other unique key and that data which you are
trying to insert already has that unique value. To diagnose, it would
be helpful to know the circumstance under which you got this error
message.
- micha
Is the CREATE TABLE you show the result of SHOW CREATE TABLE or your own
create statement? If the latter, please show the output of SHOW CREATE.
Does SELECT succeed if you remove the INSERT part of the statement?
You might want to consider adding an index on transactionlogid, this
could bring
2009/12/13 Victor Subervi :
[...]
> Please advise.
review your sql: you are inserting into
tem126072414516
and selecting from
tem126072385457
( Asterisk in Pinter Tibor's mail means "bold" )
Greetings,
Mattia Merzi.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Gods. What is this, a creche ?
*plonk*
On Sun, Dec 13, 2009 at 6:44 PM, Victor Subervi wrote:
> On Sun, Dec 13, 2009 at 12:21 PM, Pinter Tibor wrote:
>
> > Victor Subervi wrote:
> >
> >> Hi;
> >>
> >> mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2",
> "2");
> >> mysql> sele
On Sun, Dec 13, 2009 at 12:21 PM, Pinter Tibor wrote:
> Victor Subervi wrote:
>
>> Hi;
>>
>> mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2");
>> mysql> select * from *tem126072385457*;
>>
>
>
mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2");
ERRO
Victor Subervi wrote:
Hi;
mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2");
mysql> select * from *tem126072385457*;
t
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi Jason,
You may have to run "ANALYZE TABLE.." for the particular table for which you
are facing the error. So it'll rebuild the indexes. This would be the best
one to save your data.
We can use the method which Mr.Isart suggested, but it'll ignore the error
and also will lead to data loss.
Rega
Hi Jason,
if you run mysql with -f it will ignore any errors and continue importing
cat aac.sql | mysql -f -u root AAC
Isart
On Wed, Jun 17, 2009 at 8:59 PM, Jason Novotny wrote:
> Hi,
>
> I'm trying to import a dumpfile like so:
>
> cat aac.sql | mysql -u root AAC
>
> It all runs fine unti
Seems fine to me, i guess the problem is somewhere else.
Maybe you should try a full trace in Eclipse to detect the issue.
Carlos
jean claude babin wrote:
Hello,
I'm using Eclipse 3.3 and I use a model class HandlereplyModel.java to
insert values to a mysql database using mysql5.0 server.Whe
At 10:19 PM -0500 6/22/07, Chris W wrote:
when you get a duplicate key error it says something to the effect
of "Duplicate entry 'xyz' for key x"
What I want to know is how to find out what table fields are part of key x?
'show index' is what you want, I think:
http://dev.mysql.com/doc/refma
mos wrote:
Chris,
You probably want to know the specific table, so I wonder if it
shows up in the MySQL error logs? Of course you can dump the database
structure and look for key "x" by doing:
mysqldump --no-data --skip-opt --skip-comments --compact
and redirect it out to a text file. Ho
At 09:19 PM 6/22/2007, you wrote:
when you get a duplicate key error it says something to the effect of
"Duplicate entry 'xyz' for key x"
What I want to know is how to find out what table fields are part of key x?
--
Chris,
You probably want to know the specific table, so I wonder if it s
On Tue, 20 Jun 2006, css wrote:
} When someone voids a shipment in the UPS software, it sends another
} INSERT to the database, with the same data as the original row, the only
} difference being the void column is now "Y";
}
} This of course doesn't work because "Duplicate entry 'BLAHBLAH' for
If there is a way for you to capture INSERT commands and convert them to
REPLACE commands, you'll have your solution.
- Original Message -
From: "css" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, June 20, 2006 6:44 PM
Subject: Duplicate Key problem (UPS software)
I'm having a problem d
[EMAIL PROTECTED] wrote:
Ronan McGlue <[EMAIL PROTECTED]> wrote on 03/09/2006 05:05:15 AM:
> i have a little quirck with my current Mysql setup. I log all messages
> from my mtas into Mysql and then use a simple query to generate stats
> from them... as below:
>
> mysql> select exim.hour,
Ronan McGlue <[EMAIL PROTECTED]> wrote on 03/09/2006 05:05:15 AM:
> i have a little quirck with my current Mysql setup. I log all messages
> from my mtas into Mysql and then use a simple query to generate stats
> from them... as below:
>
> mysql> select exim.hour,sum(exim.count),stats.spam,stat
Ok, I found this one too. It was my own client, and of course, the
problem was on my side of things. I want to thank everyone who replied.
What was happening was I was trying to free the mysql structure and it
was already freed.
On Nov 14, 2005, at 6:50 PM, Gleb Paharenko wrote:
Hello.
O
Hello.
> Ok new problem. If for some reason, my client tries to INSERT >something
Please could you answer, what kind of client do you mean. Is it your
own client application or mysql command line client or something else?
If it is yours and it is small, you can send the code to the list,
What type client are you using?
With the C API you would test for the return value (0 or 1) and process
accordingly.
You could use 'INSERT IGNORE' syntax, but then you would not know what
records failed (you could test for how many were inserted with mysql_info()
using the C API).
See Chap
[EMAIL PROTECTED] wrote:
Does this make better sense?
Yes, many thanks and regards,
Terence
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Terence <[EMAIL PROTECTED]> wrote on 10/07/2005 03:49:46 AM:
> Hi All,
>
> I get a duplicate column error on 5.0.13 when creating a view. Am I
> doing something wrong here or do I submit a bug report? This should be
> allowed as the col names
> are not duplicated.
>
> Reproduce:
>
> create ta
Hi Terence,
I guess I was a bit unclear on my comment on the
SELECT *. Anyway you did what I meant, i.e. changed
one of your category_id's so that the set
of columnnames ( as implied by the SELECT * ) becomes
unique. What happens is that your SELECT * becomes
SELECT ticket_id,category_id,category_
> > I think your problem lies in your SELECT *
> > If you look at the columnheaders below you get category_id twice.
> > I guess you have to specify your columns with aliases.
> >
> > /Johan
> >
>
> Hi Johan,
>
> Nope, if I change the column name to category_id1 then it's okay. See
> this: (apolog
Johan Höök wrote:
Hi Terence,
I think your problem lies in your SELECT *
If you look at the columnheaders below you get category_id twice.
I guess you have to specify your columns with aliases.
/Johan
Hi Johan,
Nope, if I change the column name to category_id1 then it's okay. See
this: (ap
Hi Terence,
I think your problem lies in your SELECT *
If you look at the columnheaders below you get category_id twice.
I guess you have to specify your columns with aliases.
/Johan
SELECT * FROM ticket_master tm, category_master cm
WHERE tm.category_id = cm.category_id;
+---+
Hello.
> | 4.0.17-standard |
It is an old version of MySQL which could contain lots of bugs. It is
strongly recommended to upgrade to the latest release 4.1.12, or if it
is impossible in your production environment to 4.0.24. Usually upgrade
solves such kind of errors. Please, next
ag
>
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 30, 2005 3:20 PM
> To: mysql@lists.mysql.com
> Subject: Re: Duplicate entry error
>
>
> Hello.
>
> Please examine your master's
in for your help and cooperation.
Anurag
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 3:20 PM
To: mysql@lists.mysql.com
Subject: Re: Duplicate entry error
Hello.
Please examine your master's binary and slave's relay logs with
Hello.
Please examine your master's binary and slave's relay logs with
mysqlbinlog utility to find if sent and received SQL statements are
different. Sent your MySQL versions on master and slave. Include complete
output of 'SHOW SLAVE STATUS'. If your version is rather old, check if the
prob
Does your code properly escape the backslash character as it writes to the
database? IF you are NOT using 'cn=abc\\, def, ou=accounts' in your INSERT
and UPDATE statements, you will get values that look like 'cn=abc, def,
ou=accounts' in your data.
Without actual data, actual statements, a few
Suresh <[EMAIL PROTECTED]> wrote:
> I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a
> table with two primary key, my older mysql server insert all the records
> except the duplicate fields(Primary Key). Whereas in the new mysql
> server it exits whenever it sees a duplicate
Suresh wrote:
Hi,
Yes ofcourse it is a primary key with two fields. The insert exists whenever it
has a duplicate entry, it doesn't continue with further records. Is there any
scope to resolve it.
Thanks
Suresh
Eldo Skaria wrote:
insert ignore
--
MySQL General Mailing List
For list archives: h
Hi,
Yes ofcourse it is a primary key with two fields. The insert exists whenever it
has a duplicate entry, it doesn't continue with further records. Is there any
scope to resolve it.
Thanks
Suresh
Eldo Skaria wrote:
> Hi,
>
> Suresh may be expressing that he has a primary key with two fields.
>
Hi,
Suresh may be expressing that he has a primary key with two fields.
Eldo.
On Tue, 21 Sep 2004 19:32:17 -0400, Rhino <[EMAIL PROTECTED]> wrote:
>
> - Original Message -
> From: "Suresh" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 21, 2004 6:43 PM
> Subje
- Original Message -
From: "Suresh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 21, 2004 6:43 PM
Subject: Duplicate Entries
> Hello All,
>
> I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a
> table with two primary key, my older mysql server
- Original Message -
From: "A Z" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 21, 2004 10:02 AM
Subject: Duplicate Rows
>
>
> MySQL 4.0.14
>
> In a scenario:
>
> Ref EmailAddr
>
> 1[EMAIL PROTECTED]
> 2[EMAIL PROTECTED]
> 3[EMAIL PRO
Did you actually stop all writes to the master data while you were copying
the data over to the slave database? Is it possible that the connection you
issued the read lock with timed out before the transfer was completed?
-Original Message-
From: Alex Greg
To: [EMAIL PROTECTED]
Sent: 9/2/
cc:
Fax to:
06/28/2004 02:43 Subject: Re: Duplicate selection
on 06/27/2004 11:31 PM, Scott Haneda at [EMAIL PROTECTED] wrote:
> So, I need to basically:
> SELECT iamge_title, image_filename, image_url, image_width, image_height
> from images where user_id = '123';
>
> Then, take that result and insert all those rows in the same table, setting
> type='2' an
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 field, but it does i
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 field, but it does in greek
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 every record has a uin
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 every record has a uinque id which
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 every record has a uinque id which ofcourse is the key.
Yet, the only way I can avoid duplicates is t
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.
Some of it's columns are, name_english, surname_english,
name_original, surname_original, name_greek, surname_greek.
I have as unique each combinatio
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Samyukta Akunuru wrote:
> Hi,
>
> I am getting following error while using Hibernate with mySql.Any help
appreciated. Thank you!
>
> 2004-01-28 14:02:51,037 [main] ERROR
net.sf.hibernate.util.JDBCExceptionReporter - Invalid argument value,
message from
Chris Nolan wrote:
Hi!
There are many ways, depending on whether you want the database to
handle it, or you want your application to handle it.
What you want is a UNIQUE index on surname_original and name_original.
Assuming the table already exists:
ALTER TABLE names ADD UNIQUE(name_original,
fr0g wrote:
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.
You can create unique index on (surname_
Hi!
There are many ways, depending on whether you want the database to
handle it, or you want your application to handle it.
What you want is a UNIQUE index on surname_original and name_original.
Assuming the table already exists:
ALTER TABLE names ADD UNIQUE(name_original,surname_original);
Hi,
> 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 oth
Hi Neil,
1) You could ask for the count of each listed item in a column.
something like:
SELECT item, count(item) from parts GROUP BY item;
2) you could then use
SELECT id,item from parts WHERE item = 'xxx';
to review the double entries.
This is just a general sample, perhaps if you give mo
Title: RE: duplicate records check
Hi Neil,
try something like this
SELECT
FROM
GROUP BY
HAVING COUNT(*) > 1
Mit freundlichen Grüssen
Frank Kalis
Asset Management
ProACTIV___
CiV Versicherungen * PB Versicherungen * PB Pensionsfonds
Insert.
PB
-
- Original Message -
From: John Griffin
To: Steve Marquez ; MySQL List
Cc: PHP eMail List
Sent: Friday, June 06, 2003 2:51 PM
Subject: RE: Duplicate records
Hello Steve,
Do a select on the record before you insert it. If the record does not
exist in the
You can always catch the Duplicate Key error and respond accordingly in
your PHP script.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 1:41 PM
To: MySQL List
Cc: PHP eMail List
Subject: Duplicate records
Hello Steve,
Do a select on the record before you insert it. If the record does not exist in the
database (i.e. mysql_num_rows () == 0) than it is safe to do the insert.
John
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 3:41 PM
To: MySQL L
Simply create a UNIQUE Index on the column to avoid duplicates.
That will be case insensitive, and trailing spaces AFAIK, but spaces inside
the columns text have significance.
HTH,
Tore.
- Original Message -
From: "Dee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 02,
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
the old record is deleted before the new record is
inserted. >>
So the result was predictible, sorry having sollicited the list.
JM
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21, 2002 6:01 PM
To: [EMAIL PROTECTED]
Subject: r
BPF,
Thursday, November 21, 2002, 4:36:58 PM, you wrote:
BW> CREATE TABLE `reg_member` (
BW> `account` bigint(20) NOT NULL auto_increment,
BW> `userid` varchar(48) NOT NULL default 'Your name',
BW> `uilogin` tinyint(4) NOT NULL default '0',
BW> `id` varchar(48) NOT NULL default '',
BW> `password`
',
`joined` bigint(20) default NULL,
`expired` bigint(20) default NULL,
`status` varchar(20) NOT NULL default '',
PRIMARY KEY (`account`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM
A+
JM
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21,
Hi,
Could you give us SHOW CREATE TABLE your_table ?
Greetings from France too ;)
Jocelyn
- Original Message -
From: "BPF Webmaster" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, November 21, 2002 2:25 PM
Subject: Duplicate key delete record with same key
> Usin
Sorry, but justs a quick remark on the top:
Have you looked at small and KAPITAL letters?
--
Franz Alt
[EMAIL PROTECTED]
> at work I run mysql 3.23.45. on a windows2000 machine with apache 1.3.23
> and php4.06. at home it's Linux SuSe *.0, mysql 4.03 apache 1.3.26 and
> php4.2.3. the problem i
Graham,
Sunday, September 22, 2002, 3:15:23 PM, you wrote:
GH> I am aware that this is an error of my own making, however . . .
GH> I am unable to install my sql because the scipt fails with
GH> a duplicate key error
GH> Preparing db table
GH> Preparing host table
GH> Preparing user table
GH>
rom: "Nick Wilson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 4:57 PM
Subject: Re: duplicate entries mystery
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> * and then Nick Wilson declared
> > I'm having some weir
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Nick Wilson declared
> I'm having some weirdness when inserting from the php api, I do not get
> the same results if I use the mysql server directly. Here is the code:
Please disregard. It appears to be some bizzare Apache/http thing,
The answer is there ... :
http://www.mysql.com/doc/L/O/LOAD_DATA.html
Gurhan
-Original Message-
From: Wong Zach-CHZ013 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 8:18 PM
To: Wong Zach-CHZ013; '[EMAIL PROTECTED]'
Subject: RE: Duplicate Record
> -Ori
> -Original Message-
> From: Wong Zach-CHZ013
> Sent: Wednesday, May 22, 2002 7:11 PM
> To: [EMAIL PROTECTED]
> Subject: Duplicate Record
>
> Hi
> 1) Suppose, in a file, say testfile.sql,
> it contains a line
> eg:
> LOAD DATA INFILE "mlc_stat_" INTO table mlc FIE
There are couple of ways you can do it.
1) You can use the following sql to find out duplicate rows and then
write few more sql to delete duplicate.
SELECT column(s), count(*)
FROM
table-a
GROUP BY column(s)
HAVING count(*) > 1;
then massage the data with couple of more sqls.
2) This wa
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: Duplicate Keys
> Hi List
>
> Sor
any reason not to select distinct into a tmp table?
On Sun, 10 Feb 2002, DL Neil wrote:
> Rich,
>
> > How does one go about removing one of two identical records in a MySQL
> > database? My mistake in an earlier database was not applying a unique
> > number to each record (1, 2, 3, ---). I kn
A quick method is to create a new table:
CREATE TABLE newtable SELECT DISTINCT * FROM oldtable;
note; manually verify newtable has your data. Then proceed:
DROP TABLE oldtable;
CREATE TABLE oldtable SELECT * FROM newtable;
DROP TABLE newtable;
-Original Message-
From: Rich [mailto:[E
Dan,
[I've cc-ed this to the list and to Rich - who asked the original question]
> You can do the following to remove duplicates:
>
> - create table foo as select distinct cols from
> table_name_containing_duplicates;
> - drop table_name_containing_duplicates;
> - alter table foo rename to table_
Hi,
You can try to use ALTER IGNORE TABLE syntax :
ALTER IGNORE TABLE your_table ADD UNIQUE(Id);
Regards,
Jocelyn Fournier
- Original Message -
From: "Rich" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 5:31 PM
Subject: Duplicate Records
> How do
Rich,
> How does one go about removing one of two identical records in a MySQL
> database? My mistake in an earlier database was not applying a unique
> number to each record (1, 2, 3, ---). I know it's possible to use the
> DISTINCT operator to show only one of the identical records in a resul
avoid duplicates.
Regards,
Dan
> -Original Message-
> From: DL Neil [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 11 February 2002 8:30 a.m.
> To: Rich; MySql
> Subject: Re: Duplicate Records
>
>
> Rich,
>
> > How does one go about removing one of two identica
Hi,
You can try to use ALTER IGNORE TABLE syntax :
ALTER IGNORE TABLE your_table ADD UNIQUE(Id);
Regards,
Jocelyn Fournier
- Original Message -
From: "Rich" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 5:31 PM
Subject: Duplicate Records
> How do
Rich,
> How does one go about removing one of two identical records in a MySQL
> database? My mistake in an earlier database was not applying a unique
> number to each record (1, 2, 3, ---). I know it's possible to use the
> DISTINCT operator to show only one of the identical records in a resul
First off,
You would need to add an "id" field, then set it to a primary key, then
set it to "auto_increment"
This will order them correctly
-Original Message-
From: Rich [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 10, 2002 10:31 AM
To: MySql
Subject: Duplicate Records
How does
"Brad Harriger" <[EMAIL PROTECTED]> wrote:
> How does MySQL handle duplicate column names?
Kind of open ended, but I'll give it a shot. MySQL doesn't allow duplicate
column names within a table, but if you are referring to a query accessing
multiple tables containing fields with the same name th
Okay, so I did some detective work and found the problem. I thought you
might want to know the cause.
I use Textpad as my HTML editor right now, and when you create an HTML file
from scratch, it has the following tag:
The BACKGROUND="?" part was causing the problem. When I remove ONLY that
p
ALTER IGNORE TABLE mytable ADD UNIQUE (email);
will both add a unique key ( which will avoide this problem in the
future ) and delete the duplicates.
Rory O'Connor wrote:
> excuse me if this is too newbie...but I need to perform a duplicate
> delete on my database using the e-mail address as
Rory O'Connor writes:
> I want to leave one record behind, but delete all other records that
> have the same e-mail address. Is there a standard query for this or do
> I need to write a script that will do it?
Getting a list of the duplicate rows is simple enough, but
deleting them requires a
I want to leave one record behind, but delete all other records that
have the same e-mail address. Is there a standard query for this or do
I need to write a script that will do it?
THanks,
Rory
On Thu, 30 Aug 2001 22:35:48 -0500, "Rory O'Connor" <[EMAIL PROTECTED]>
wrote:
>Do you want to dele
Do you want to delete all records which have duplicates, or do you want to
delete all the duplicates but leaving one copy of each duplicated record
behind?
- Original Message -
From: "Rory O'Connor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 4:50 PM
Subje
Ivan Lulukyan writes:
> Hi All.
> Strange thing.The query below:
>
> select concat(domain,path,file) as url, title, '' as blank1, docdate, size,
> date as lastmod, 'keywords' as keyw, description as descr, a.ID, sum((word
> like 'acc')) as r, ( sum(word like 'acc')) as qu, f.ID, author,
> class,c
Dear Ivan,
I am full of admiration for your huge number of left joins in this
query! :-)
Looks quite funny to me how a SELECT can produce an error that you would
expect from an INSERT query. Anyway, try to type this query into a
multi-line command line (MySQL Monitor, the command line tool), and
Try to design your tables so, that it would be impossible to enter
dublicate primary keys. And don't let users (if it's CGi application) to
set or play with your primary keys (well, we could talk more about this
one).
If you used AUTO_INCREMENT, or UNIQUE, I bet you wouldn't have such
problem.
Thanks Cal,
Anything in particular in the config I should be looking for?
Thanks,
Tyrone
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 9:40 AM
To: Mysql@Lists. Mysql. Com
Subject: RE: Duplicate entry '0' for key 1
Other than the f
levans.com
-Original Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 11:24 AM
To: Mysql@Lists. Mysql. Com
Subject: RE: Duplicate entry '0' for key 1
Here's the CREATE TABLE syntax I used on the latest table to do this to
me...
CREATE TABLE sit
[mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 9:06 AM
To: Tyrone Mills; Mysql@Lists. Mysql. Com
Subject: RE: Duplicate entry '0' for key 1
What's your datatype?
Cal
http://www.calevans.com
-Original Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Su
What's your datatype?
Cal
http://www.calevans.com
-Original Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 10:59 AM
To: Mysql@Lists. Mysql. Com
Subject: Duplicate entry '0' for key 1
Importance: High
Why is it that a seemingly random intervals anyo
oincrement
problems at virtually the same time. And this is the only app running on
this system. Why did MySql decide these 2 keys already exist when in fact
they don't?
>From: Gerald Clark <[EMAIL PROTECTED]>
>To: Dan Shapella <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
What operating system are you running, and how big are these files and
indicies?
Is this a 2 Gig file size limit problem?
You are getting near the limit to the size of an unsigned mediumint.
Dan Shapella wrote:
>
> I have a weird one here.
>
> I have an application that inserts records into
On Fri, 6 Apr 2001, Vigile wrote:
> Date: Fri, 6 Apr 2001 01:26:05 -0400
> From: Vigile <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Duplicate of Everything in Table
>
> I have a table, that DOES NOT have a primary key, but is setup like this:
>
> Field Type Attributes Null Defa
lds I can't do that.
> > > >
> > > > Ryan Shrout
> > > > Production Manager
> > > > Athlonmb.com
> > > > http://www.athlonmb.com
> > > > [EMAIL PROTECTED]
> > > >
> > > > - Original Message -
> &
er
> > > Athlonmb.com
> > > http://www.athlonmb.com
> > > [EMAIL PROTECTED]
> > >
> > > - Original Message -
> > > From: "Gerald Clark" <[EMAIL PROTECTED]>
> > > To: "Vigile" <[EMAIL PROTECTED]>
> >
1 - 100 of 112 matches
Mail list logo
