Jay Pankhaniya
How much "NULL" values you can define for the "NULL" Data Type Column in SQL ?

The Short details of this question is that if i have a database let’s say an fruit and i have define a the table as fruit_details_tbl . So, inside this table i have a column for the different criteria or aspects you can say like a color , shape, taste,etc. So, Now i have made a shape as NULL and other fields as required then how much null value i can specify for that column.

Create table fruit_details_tbl(name varchar(20) NOT NULL,shape varchar(20) NULL ,color varchar(20) NOT NULL,taste varchar(20) NOT NULL);

By Jay Pankhaniya in SQL on Aug 15 2021


Most Popular Job Functions


MOST LIKED QUESTIONS