Hello, mysql, p_asset CREATE TABLE `p_asset` (\ `ano` int(11) NOT NULL auto_increment,\ `asset_name` varchar(50) NOT NULL default '',\ `asset_type` int(11) default NULL,\ `asset_format` varchar(50) default NULL,\ `asset_keywords` varchar(200) default NULL,\ `asset_duration` bigint(20) default NULL,\ `asset_status` varchar(10) default NULL,\ `asset_channel` varchar(20) default NULL,\ PRIMARY KEY (`ano`),\ UNIQUE KEY `asset_name_2` (`asset_name`),\ KEY `p_asset_name_idx01` (`asset_name`)\ ) TYPE=InnoDB
According to the manual,there is no 'drop unique key' in alter command I attempt to type 'alter table p_asset drop index asset_name',but it doesn't functional. alter table p_asset drop unique key( asset_name),obviously it wouldn't take effect. How can I drop the unique in p_asset table? Best regards. MaFai [EMAIL PROTECTED] 2003-06-30
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
