[AccessD] 2 MySql posers

Thanks very much, Arthur. Much obliged. Cheers
paul 

-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com]
Sent: 13 December 2004 05:12
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] 2 MySql posers


There may be a dozen ways, but one obvious one is to run this statement::

SHOW CREATE TABLE mytable;

and either pipe the result to a text file or just copy the result and 
paste it into a text editor. Then edit said file and run the SQL, 
creating myNewTable with the PK of your choice. Finally:

INSERT INTO myNewTable SELECT * FROM mytable

You probably wouldn't want to use * but you get the idea.

HTH,
Arthur

Paul Rodgers wrote:

>Is there a simple way to rename a Primary Key column in MySql, please? None
>is listed in my tutorials. 
>
>One way might be to delete the column and add a replacement. But once
>records are introduced, it seems, I can't replace a Primary Key column. Be
>grateful for guidance from one of our gurus please.
>
>Is there a simple way to back-up a table in MySql? I keep getting caught
out
>by forgetting WHERE and messing up masses of rows. 
>
>Cheers
>
>paul
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.0 - Release Date: 12/9/2004

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com