Unix Technical Forum

renaming multiple tables and retain foreign keys

This is a discussion on renaming multiple tables and retain foreign keys within the MySQL forums, part of the Database Server Software category; --> I have 3 tables with foreign keys limited to the that group of tables. I need to create temp ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-28-2008, 04:40 AM
Coltrane
 
Posts: n/a
Default renaming multiple tables and retain foreign keys

I have 3 tables with foreign keys limited to the that group of
tables.
I need to create temp tables with new data create the foreign keys
and then replace the current tables with the new tables.
how can I do this with retaining the foreign keys

thanks for the help

john
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-28-2008, 04:40 AM
Paul Lautman
 
Posts: n/a
Default Re: renaming multiple tables and retain foreign keys

Coltrane wrote:
>I have 3 tables with foreign keys limited to the that group of
> tables.
> I need to create temp tables with new data create the foreign keys
> and then replace the current tables with the new tables.
> how can I do this with retaining the foreign keys
>
> thanks for the help
>
> john


Can you try re-writing this with some punctuation? As it stands I can't
figure out what it is supposed to mean.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:19 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com