-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, all --
What's the best way to change your database schema around if you have data in it? How do you know when to simply ALTER TABLE and when to dump the whole thing (perhaps doing specific SELECTs to spit out the data you'd like to have in the end to be processed by some script that will make the new table structure)? I don't have a good example, but suppose I have a few tables with some fields each and I realize that I should make a new table with data from some columns of some tables. What to do? TIA & HAND & Happy Holidays mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+DQB2Gb7uCXufRwARAoiYAJ9ImPYzudn5iVy6a2VaxF9hZpT0QQCgm5A8 V9U37FV1f/Xk6VVRbPa8A9I= =XKu3 -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
