In order to convert a field from NOT NULL to NULL use below stated SQL :
ALTER TABLE TABLENAME MODIFY FIELD NAME NULL;
In order to convert a field from NULL to NOT NULL use below stated SQL :
ALTER TABLE TABLENAME MODIFY FIELD NAME NOT NULL;
ALTER TABLE TABLENAME MODIFY FIELD NAME NULL;
In order to convert a field from NULL to NOT NULL use below stated SQL :
ALTER TABLE TABLENAME MODIFY FIELD NAME NOT NULL;
No comments:
Post a Comment