What version of MySQL? What interface are you using to execute the delete?
How do you know you only deleted one of the records? From a CLI, without a PK, there would be no way to delete only one. Delete from Works where title = something would delete both of them. =C= * * Cal Evans * Techno-Mage * http://www.calevans.com * ----- Original Message ----- From: "Nick Traenkner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 11:32 AM Subject: delete corrupts > sql query > > once again... > > I am using PHP. > > i have a table (called Works) with two fulltext indices, one (Title) is a > varchar(64) and the other (Desc) is a longtext. > > when there are two records having the same value in Title and I delete one > of the records i recieve the following result from "check table Works" > > +---------------+-------+----------+-----------------------+ > | Table | Op | Msg_type | Msg_text | > +---------------+-------+----------+-----------------------+ > | Works | check | error | Found 825 keys of 826 | > | 67046_3.Works | check | error | Corrupt | > +---------------+-------+----------+-----------------------+ > > i am nearing wits end. this does not happen on windows 2000, only on linux. > > -nick > > > > --------------------------------------------------------------------- > 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
