Mailing List Archive


Back to the month index Back to the list index
Vivek Khera (khera@kci.kciLink.com)
Thu, 26 Sep 1996 10:46:22 -0400 

Message-Id: <199609261446.KAA10074@kci.kciLink.com>
Subject: Re: [mSQL] adding fields 
Date: Thu, 26 Sep 1996 10:46:22 -0400
From: Vivek Khera <khera@kci.kciLink.com>

+---------
| I'd simply like to restructure my database tables without hand-editing
| all of the data. Is there something out there that will read a
| new database tables definition, redefine the tables, and add NULL
| fields to the existing data as needed?
+---------

Use the new "-c" option to msqldump to get a COMPLETE insert statement, then
you don't need to modify any of them, just add the necessary fields to your
table definition, drop the table, then re-load it from the dump.

                                                                v.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-301-258-8292
PGP/MIME spoken here http://www.kciLink.com/home/khera/
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!