hi,
I receive this error when I export/import a table from a database to another one:
Error
SQL query:
--
-- Database: `mil`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_taoj`
--
CREATE TABLE IF NOT EXISTS `jos_taoj` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`extension` VARCHAR( 100 ) NOT NULL COMMENT 'The extension',
`version` VARCHAR( 16 ) NOT NULL COMMENT 'Version number',
`installed_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date-time modified or installed',
`log` MEDIUMTEXT,
PRIMARY KEY ( `id` ) USING BTREE,
KEY `idx_extension` ( `extension` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COMMENT = 'The Art of Joomla extension version history' AUTO_INCREMENT =2;
MySQL said:
#1064 - Erreur de syntaxe pr�s de 'USING BTREE,
KEY `idx_extension` (`extension`)
) ENGINE=MyISAM' � la ligne 7
could you give me some help ?
thanks