This week's book giveaways are in the Jython/Python and Object-Oriented programming forums. We're giving away four copies each of Machine Learning for Business: Using Amazon SageMaker and Jupyter and Object Design Style Guide and have the authors on-line! See this thread and this one for details.
I'm not sure what you want to delete. That column? (An ALTER TABLE statement.) The rows which contain NULL in that column? (A DELETE FROM TABLE WHERE ... IS NULL statement.) Or did you have something else in mind?
sarojni agrwal wrote:how to delete Null value here?
A NULL value means that there is no value for the record in that database table column. So I don't really understand why you want to delete this value It's merely a representation of MySQL Workbench of a NULL value. So you should provide more details about what you are trying to achieve.
Hi, I want to delete null values from column in database because , I got NullPointerException when I find length of image in java application, well when I run both queries , it did not remove null values.
1)DELETE FROM extra WHERE 'Image' = "null";
2)ALTER TABLE extra ALTER COLUMN Image DROP DEFAULT;