Hola que tal.
aqui pensando sobre una cuestion, se puede borrar todas las columnas menos una?
mirando la sintaxis del alter table:
[mysql:kghxzkgn]
-
- ALTER [IGNORE] TABLE tbl_name
- alter_specification [, alter_specification] ...
- alter_specification:
- ADD [COLUMN] column_definition [FIRST | AFTER col_name ]
- | ADD [COLUMN] (column_definition,...)
- | ADD INDEX [index_name] [index_type] (index_col_name,...)
- | ADD [CONSTRAINT [symbol]]
- PRIMARY KEY [index_type] (index_col_name,...)
- | ADD [CONSTRAINT [symbol]]
- UNIQUE [index_name] [index_type] (index_col_name,...)
- | ADD [FULLTEXT|SPATIAL] [index_name] (index_col_name,...)
- | ADD [CONSTRAINT [symbol]]
- FOREIGN KEY [index_name] (index_col_name,...)
- [reference_definition]
- | ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
- | CHANGE [COLUMN] old_col_name column_definition
- [FIRST|AFTER col_name]
- | MODIFY [COLUMN] column_definition [FIRST | AFTER col_name]
- | DROP [COLUMN] col_name
- | DROP PRIMARY KEY
- | DROP INDEX index_name
- | DROP FOREIGN KEY fk_symbol
- | DISABLE KEYS
- | ENABLE KEYS
- | RENAME [TO] new_tbl_name
- | ORDER BY col_name
- | CONVERT TO CHARACTER SET charset_name [COLLATE collation_name]
- | [DEFAULT] CHARACTER SET charset_name [COLLATE collation_name]
- | DISCARD TABLESPACE
- | IMPORT TABLESPACE
- | table_options
-
[/mysql:kghxzkgn]
solo veo la opcion de poder borrar la columna que yo le diga, pero no veo la forma de varias columnas.
se podra hacer esto? o alucino?
saludos
gracias.
PD: no veo el where. o algo por el estilo
