MaFai wrote:
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
Try:
alter table p_asset drop index asset_name2;
Regards,
Joseph Bueno
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
