[SOLVED] SET UNUSED COLUMN for MySQL ?

[Zwiter]

Hello,

I would like to know if it is possible to desactivate columns in MySQl, the same way oracle do with SET UNUSED COLUMN.

I am using myISAM tables.

 

Thank you,

Z.

[fenway]

Not that I know of... why would you want to?

[Zwiter]

because there is data in theses columns, and I may still have to use them in the future. I dont want to delete anything as i am developping a web application.

Z.

[Flames]

it seems pretty useless to have a function called SET UNUSED COLUMN because really you dont need a function for it, all you need to do is not use the column it will stay there, all the data will stay there and you can use the column in the future.

[Zwiter]

for you, it is useless, but not for me.

I perform different actions based on a part of the columns name, and sometimes on the whole columns.

im not doing a website, i am doing a web application, for a very specific usage, in schitific research.

But now, forget all this, i have backed up my table, and delete the columns. i fi need them again, i will alter the table, and use a script to take back the data.

 

Z.