>>Why 7 steps if you can do a simple ALTER TABLE?

Because the command is ALTER TABLE, but not ALTER TABLES,
Because the 7 steps are within reach, no typos and so on, no detailled SQL knowledge reached that I do not yet have,
Because 30 tables would be 30 steps with your method (the "30" is just in my case, of an experimental phpBB)
(For one table I need zero SQL , as I did it interactively in phpmyAdmin in step (1)).

We would need one command that produces 30 ALTER TABLE (with automatic table list), or some other mechanic procedure to produce the ALTERs at once



Edited 2 time(s). Last edit at 02/26/2006 05:04AM by PeterSwiss .