<tutorialjinni.com/>

MySQL Replace NULL With 0 in SELECT Statement

Posted Under: Database on Nov 11, 2016
MySQL Replace NULL With 0 in SELECT Statement
When you make a Left Join or make a UNION query the DBMS will put NULL where their is no match in the set. This tutorial is aimed to discuss the options by which NULL can be substituted with 0 in MySQL DBMS.
Full Post ❱❱

Point of Sale ERD

Posted Under: Database on Sep 14, 2011
Point of Sale ERD
Point of Sale Entity Relationship Diagram (ERD) Sample.
Full Post ❱❱

School Management System ERD Diagram

Posted Under: Database on Sep 12, 2011
School Management System ERD Diagram
A Database is required to support an Online school system which should be so generic that any number of schools in an area, (eg Town/country/world) can register to use the System.
Full Post ❱❱