Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Regarding the MySQL Cluster documentation we are not allowed to modify a column to NOT NULL on ONLINE tables. i.e.

ALTER TABLEfoo_barMODIFY COLUMNbazdecimal(11,8) NOT NULL

Our hosting provider tells us the same limitation also applies to OFFLINE tables, but I cannot find any indication in the documentation confirming this. In their opinion the only possible solution to modify or add a NOT NULL column is to recreate the whole table.

Can someone tell me if the above statement is right? What are the best steps to apply this schema change?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.