0
I have a table with 129 columns and over 400 records, and due to some changes in the structure, I will need to redo it from scratch. But I would like to take advantage of the content related to column1, column2 and column3.
When I go to "export" I don’t see option to define which columns I need to save the values.
How can I do that ?
I don’t know if I understand what you mean by "export" but you can create an auxiliary table, copy the existing table, and do:
INSERT INTO auxiliar(coluna1, coluna2, coluna3) (SELECT coluna1, coluna2, coluna3 FROM sua_tabela), then just remove your old table and rename the auxiliary.– anonimo
Hmmm, good idea on. I think I will do just that, it will be very practical. Thank you very much :)))
– Top Sonhos
the suggestion do@anonimo seems the best opição, I will only comment to suggest that it takes to model even this table, a single table with 129 columns is bizarre :)
– Ricardo Pontual