Greetings I have a table and I want to make a copy of it in the same database. I only keep the structure and indexes and not the data.
I issue a command - create table `aimdb`.`mtv20030105spots_copy` ( primary key ( AdInstanceID ) ,FULLTEXT KEY `KeyNumber` ( `KeyNumber` ), FULLTEXT KEY `AdvertisementID` ( `AdvertisementID` ) )type=MyISAM select `AdInstanceID`, `AdvertisementID`, `KeyNumber`, `StationID`, `SpotDateTime`, `Duration`, `BreakNumber`, `AdsInBreak`, `PositionInBreak`, `PromoBefore`, `PromoAfter`, `TypeOfAd`, `CommentCode`, `ProgramID`, `MarketInd` from `aimdb`.`mtv20030105spots` where 1 = 0 MySQL giving me error - 'Cant create Tablename.frm(...)' I am running 4.0.13 on Win98? Can somebody tell me whats wrong? Karam __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]