Home / MySQL / mysql online tutorial – Null column type
The NULL column type is special in many ways. To insert a NULL value, just leave the column name from the INSERT statement. Columns have NULL as default unless specified by NOT NULL. You can have null values for integers as well as text or binary data.
NULL cannot be compared using arithmetic operators. Comparisons for NULL take place with IS NULL or IS NOT NULL.
select e_id, children from employee_per where children IS NOT NULL; +------+----------+ | e_id | children | +------+----------+ | 2 | 3 | | 3 | 2 | | 7 | 3 | | 9 | 1 | | 11 | 4 | | 12 | 3 | | 13 | 2 | | 15 | 3 | | 16 | 2 | | 17 | 1 | | 21 | 2 | +------+----------+ 11 rows in set (0.00 sec)
The above lists ids and no. of children of all employees who have children.
How do I view a deleted web page?
Is there a way to view a deleted web page - one that is no longer available? Yes there is and the solution is quite simple. [more...]
Hard disk storage capacities have been increasing over the years. The world's first hard disk, IBM 350 Disk File, could store 5MB of data was announced on 4th September 1956. The first 1TB drive appeared 51 years later in 2007. It took just a couple of years to double the capacity and the first 2GB drive came into the market in 2009. [more...]
We use cookies to give you the best possible website experience. By using WebDevelopersNotes.com, you agree to our Privacy Policy