Perhaps a better way would be to do a msqldump, making sure that it also adds the column names for the insert command. Edit the output to include the new field in the create table statement, then do a msql databasename <<foo.msql . This will recreate the table with the new column, and when it inserts the data back into the table, it will put it into the correct columns.


At 01:05 PM 12/10/99 +0000, Warren Killian wrote:

>Hi Francois,

>

>Not too long ago, a very savvy UNIX user pointed out that after using

>msqlexport, you could then use the UNIX commands "cut" and "paste" to

>split the exportfile anywhere you wanted and insert new columns.  Then,

>recreate the database with the new required table structure and import

>the new data.  It's a VERY handy and fast way of manipulating your

>tables.  I forgot his name, but kudos to whoever pointed those commands

>out to the list.  Hope this helps.

>

>Francois.Hamonno@alcatel.fr wrote:

>> 

>> According to the FAQ, ALTER TABLE command is still not available in mSQL2.

>> Did somebody work on a way to alter the structure of an existing table (eg adding new columns)?

>> 

>> Another of my current needs: roll-back function to preserve base integrity in case of pb arising during update of linked tables. Does someone have a utility available?

>> 

>> Thanks for the help

>> Amities...

>>    Francois

>> 

>> -------------------------------------------------------------------------

>> To unsubscribe, go to http://www.Hughes.com.au/extras/email/

>

>-- 

>Thank you,

>Warren Killian

>Wishard Health Services

>1001 W. 10'th St.

>Indianapolis, IN 46202

>E-mail: killianw@wishard.edu

>Ph: 317.630.8954

>Pager: 317.212.8768

>-------------------------------------------------------------------------

>To unsubscribe, go to http://www.Hughes.com.au/extras/email/

>

<bold><bigger>Jonathan Swaby

</bigger>Computer Services Specialist IV

Student Affairs 

Phone: 404-894-5889

Fax:   404-894-9928

<color><param>0000,0000,8080</param><bigger><bigger>
Georgia</bigger></bigger></color></bold><bigger><bigger><italic><color><param>8080,8080,0000</param>Institute

of</color></italic><bold><color><param>0000,0000,8080</param>Tech</color></bold><italic><color><param>8080,8080,0000</param>nology

</color></italic></bigger></bigger>


-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/