Cant duplicate table??? - MySQL Database

Karam Chand

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/my***********...ie.nctu.edu.tw

Jul 19 '05 #1

Subscribe Reply

3248

Similar topics

3200

Duplicate Field Script

by: Giloosh | last post by:

Hello, i need some help if possible... i have a payments table with over 500 records i want to run a query that searches through the table spotting out any duplicate ID#'s and Dates. So basically...

Visual Basic 4 / 5 / 6

4623

How to eliminate duplicate IDs from a table

by: Francesco Moi | last post by:

Hello. I've got a 'books' table with 'id', 'name', 'author' and 'isbn' fields. Due to an error, my books are duplicated, so I've got (e.g.): 430 - Moby Dick - Herman Melville - 0192833855...

MySQL Database

1918

Duplicate values

by: Pablo | last post by:

Hello, there, I have a table tblData which has pharmacy data. The table has following fields: ClaimNum, LineNum... The ClaimNum has claim number which is 12 characters. LineNum is NULL. The...

Microsoft Access / VBA

3653

Getting rid of duplicate tables.

by: Jared Carr | last post by:

First I wish I knew how this was caused but here is our problem. Sometime in the recent past we got a duplicate table. Here is the result of a pg_dump with a pg_restore for just that table. ...

PostgreSQL Database

9763

MySql UPDATE problem with duplicate rows

by: Jon Maz | last post by:

Hi, I have a MySql problem I hope someone can help me with. I'm trying to run an update on a linking table, the update is running into a Primary Key constraint violation, and in my workaround...

MySQL Database

3973

Deleting duplicate entries from MySQL database table

by: Manish | last post by:

The topic is related to MySQL database. Suppose a table "address" contains the following records ------------------------------------------------------- | name | address | phone |...

PHP

3904

Duplicate Entry Check - for Allan Browne

by: Iona | last post by:

Hi Allan, I'm using a nifty piece of code you put on here some time back to do a duplicate entry check as below. I'm using to check for duplicate names. However I am getting an error message on...

Microsoft Access / VBA

10928

Delete Duplicate record from SQL Server2000

by: rajeshkrsingh | last post by:

Hi friends, Step1- create table duplicate ( intId int, varName varchar(50) ) insert into duplicate(intId,varName) values(1,'rajesh') insert into duplicate(intId,varName) values(2,'raj12')...

Microsoft SQL Server

2860

Delete Duplicate Values

by: ramdil | last post by:

Hi All I have table and it have around 90000 records.Its primary key is autonumber field and it has also have date column and name, then some other columns Now i have problem with the table,as my...

Microsoft Access / VBA

7125

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7165

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7203

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6885

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7379

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

4588

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3093

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3081

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

290

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General