MySQL rename and indexes

トップ ページ
添付ファイル:
Eメールのメッセージ
+ (text/plain)
このメッセージを削除
このメッセージに返信
著者: der.hans
日付:  
To: quatsch
題目: MySQL rename and indexes
moin moin,

I've got a couple of MySQL questions.

I see the "show index from $table" option for the mysql client, but it
doesn't list index names. How does one obtain the index names?

When renaming a table do the indexes for the table follow it to the new
name? If they do, do the index names also get adjusted?

Any tips on creating a new table and indexes based on another table and
its indexes?

ciao,

der.hans
-- 
#  https://www.LuftHans.com/        http://www.CiscoLearning.org/
#  Sysdamin Days Phoenix, 6-7 Nov, now with edu discount  https://LOPSA.org/
#  To announce that there must be no criticism of the President, or that we
#  are to stand by the President, right or wrong, is not only unpatriotic
#  and servile, but is morally treasonable to the American public.
#  -- Theodore Roosevelt, editorial in the Kansas City Star, 07May1918
---------------------------------------------------
PLUG-discuss mailing list - 
To subscribe, unsubscribe, or to change  you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss