I did a CHECK TABLE and it reported no errors.
Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com From: Rodrigo Marins [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 19, 2007 7:07 PM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Forbidden subquery Hy , i´ve done some search regarding your issue and i think you may find this interesting : <http://forums.devshed.com/mysql-help-4/got-error-134-from-storage-engine-er ror-number-1030t-446448.html> http://forums.devshed.com/mysql-help-4/got-error-134-from-storage-engine-err or-number-1030t-446448.html http://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html 2007/12/19, Jerry Schwartz < [EMAIL PROTECTED]>: What I want to accomplish is expressed best as DELETE FROM prod_price WHERE prod_price.prod_price_chg_flag = "O" AND prod_price.prod_id IN (SELECT prod_price.prod_id FROM prod_price WHERE prod_price.prod_price_chg_flag = "X") ; This is clear, concise, and completely illegal. I want to delete every "O" record which has an accompanying "X" record. I tried using a self-join like this DELETE FROM p1 USING prod_price AS p1 JOIN prod_price AS p2 ON p1.prod_id = p2.prod_id WHERE p1.prod_price_chg_flag = "O" AND p2.prod_price_chg_flag = "X" ; And got a storage engine error 134 (MyISAM table). I'm not even certain that this would have done what I wanted, but I guess I won't find out. Here's what the table prod_price looks like: Table: prod_price Create Table: CREATE TABLE `prod_price` ( `prod_price_id` varchar(15) NOT NULL default '', `prod_id` varchar(15) default NULL, `prod_price_del_format` varchar(255) default NULL, `prod_price_val_date` date default NULL, `prod_price_chg_flag` char(1) default NULL, `prod_price_disp_curr` varchar(10) default NULL, `prod_price_disp_price` decimal(10,2) default NULL, `prod_price_end_curr` varchar(10) default NULL, `prod_price_end_price` decimal(10,2) default NULL, `prod_price_reg_price` varchar(5) default NULL, `prod_price_changed` tinyint(1) default NULL, `prod_price_added` datetime default NULL, `prod_price_updated` datetime default NULL, PRIMARY KEY (`prod_price_id`), KEY `prod_id` (`prod_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 I'm running 5.0.45-community-nt. Suggestions? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Rodrigo Marins Gerência de Controle e Desempenho de Sistemas GRUPO TELEFÔNICA NO BRASIL Rua Xavier Curado,473 9° andar CEP 04210-100 São Paulo - SP Tel: 55 11-6166-3163 / 8152-1112 [EMAIL PROTECTED] http://www.telefonica.com.br - PgConBrasil: dias 7-8 dezembro 2007 http://pgcon.postgresql.org.br
