Bases de Datos > MySQL

 Borrar Todas La Columnas Menos Una, Se Puede Con A

(1/1)

sakuragi:
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_namealter_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
 :comp:

Navegación

[0] Índice de Mensajes