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/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:04:03 EST