is it possible to delete a column from a table in mysql using php?
If not, how can I make sure that column is empty and then copy all the other columns to a different table, then delete the first table?
delete columns
Moderator: General Moderators
-
jaymoore_299
- Forum Contributor
- Posts: 128
- Joined: Wed May 11, 2005 6:40 pm
- Contact:
Code: Select all
ALTER TABLE 'table' DROP 'column'-
jaymoore_299
- Forum Contributor
- Posts: 128
- Joined: Wed May 11, 2005 6:40 pm
- Contact:
Code: Select all
ALTER TABLE `db`.`table`
ADD COLUMN `NewField` int(11) NULL;
ALTER TABLE `db`.`table`
DROP COLUMN `NewField`;