Using WinMySQL Professional

Make a column not null

Only accessible when connected and when a table is active, the «Table management>Make a column not null» submenu allows to quickly alter a table structure to add a «NOT NUL» option on a column. The user who wants to perform this operation must have, at least the «Can ALTER» privilege.

The main target of this feature is to offer an easy way to prepare a column to receive an index (see «Submenu Table management>Add index section)».

To perform this operation, invoke the «Table management>Make a column not null» submenu clicking on it or using the «Ctrl-F10» shortcut. Then, the «Columns list» screen appears. Select the column on which you wish apply the directive and click on the «Select» button. To complete the operation, confirm your choice.