hi.
check out a book or online tutorial on database normalization. even a mildly
normalized database will provide a way to uniquely reference a row.
otherwise, you can use:
delete from table1 where c1 = 10 and c2 = 'MySQL' limit 1;
that will delete one row only, and if the rows are truly identical, it won't
matter which of them (third one, first one, second one) you delete.
-ravi.
-----Original Message-----
From: LAMULA LALLAL [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 2:47 AM
To: [EMAIL PROTECTED]
Subject: Row to delete
Hi
Can some one help me for this issue.
When I have multiple rows with the same duplicated
data in the table, how can I delete a perticular row
only ?
For example I have the table TABLE1 with C1 INT and C2
VARCHAR(20) with the following rows of data
C1 C2
=========
10 MySQL
20 MySQLAB
10 MySQL
10 MySQL
If I want to delete only the 3rd row, with out
deleting other rows. Is it possible in MySQL ?
Thank you
Lalal
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php