Zwiter Posted July 18, 2008 Share Posted July 18, 2008 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 23, 2008 Share Posted July 23, 2008 Not that I know of... why would you want to? Quote Link to comment Share on other sites More sharing options...
Zwiter Posted July 24, 2008 Author Share Posted July 24, 2008 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. Quote Link to comment Share on other sites More sharing options...
Flames Posted July 24, 2008 Share Posted July 24, 2008 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. Quote Link to comment Share on other sites More sharing options...
Zwiter Posted July 25, 2008 Author Share Posted July 25, 2008 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.