Mysql: query is not executing

Question

The below query is not executing .. Please let me know the problem..

CREATE TABLE IF NOT EXISTS `catalog_category_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT,
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0',
  `value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `IDX_BASE` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`) USING BTREE,
  KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` (`entity_id`),
  KEY `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE` (`attribute_id`),
  KEY `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE` (`store_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1122 ;

This table belongs to the Magento Project..

yes i have permission to create. There is no permission problem.. — Miko
– Miko, Commented Apr 27, 2011 at 5:39
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE, KEY FK_ATTRIBUTE_VARCHAR_ENTITY` (entity_id), KEY FK_CATA' at line 9 This is the error is showing when i try execute in phpmyadmin. — Miko
– Miko, Commented Apr 27, 2011 at 5:40
In the above query what this line is meant?? Is referring to any other table?? KEY 'FK_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE' ('attribute_id'), — Miko
– Miko, Commented Apr 27, 2011 at 5:46
@Mayilarun: it creates a key field based on the attribute_id to speed up queries. — wallyk
– wallyk, Commented Apr 27, 2011 at 5:50

piotrm · Accepted Answer · 2011-04-27 05:49:24Z

2

In mysql versions prior to 5.1 you have to use USING BTREE before parenthesis. Try changing

UNIQUE KEY `IDX_BASE` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`) USING BTREE

to

UNIQUE KEY `IDX_BASE` USING BTREE (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`)

answered Apr 27, 2011 at 5:49

piotrm

12.4k5 gold badges33 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql: query is not executing

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related