Hi again,
Is there a quick and dirty way that I am missing for creating a new
database with a slightly different schema than the old db?
For example, I have a table with a DATETIME field that I really need to
change to a DATE field.
I can create a new table with that field defined as a DATE, but if I do
the following:
INSERT INTO newtable SELECT * FROM oldtable;
I get an data type error.
Is there a "Standard", quick method for doing something like that?
Thanks much.
--
Stand Fast,
tjg.
Chief Technology Officer tjg@exceptionalminds.com
Red Hat Certified Engineer www.exceptionalminds.com
Avalon Technology Group, Inc. (503) 246-3630
>>>>>>>>>>>>Linux...Because rebooting isn't normal<<<<<<<<<<<<