© 2023 Hashnode
#sql
Prerequisites: Good practical knowledge of Core Java(specially oops concepts like Inheritance, Polymorphism, Interface, Classes, Objects, etc. Exception Handling, and multi-threading). Basic practical…
The COALESCE function in MySQL is used to return the first non-NULL value in a list of expressions. If all expressions are NULL, the function returns NULL. This function is useful for handling missing…
SQL i.e. Structured Query Language is one of the most widely known query languages for processing and manipulating data. Although SQL is easy to comprehend and implement, it is a storehouse of functio…
Introduction Definition of ORM (Object-Relational Mapping) ORM, short for Object-Relational Mapping, is a technique used in software development to bridge the gap between the object-oriented programmi…
So far, we've looked at how to use foreign keys and relationship attributes to create database relationships. We've also seen how doing an implicit SQL I/O throws errors. Next, we are going to cover t…
Have you ever heard of the "Golden Hammer"? No, it's not a tool made of gold (although that would be quite the showstopper in a handyman's toolkit). It's a term used in the software development world …
The IFNULL() function in MySQL is a useful tool that allows you to replace NULL values with a specified value. Points To Remember: The IFNULL() function takes two arguments: the expression to be eval…
Companies are currently collecting and working on large amounts of data each day. The handling of this big data requires structured algorithms and precise calculations and this is where Machine Learning comes into the picture. However, Mach…
The convention is to capitalize the actual SQL keywords. Differentiate them from table and column names. This makes it easier for people to read the statements SELECT SELECT column_name FROM table_nam…
Are you having trouble resetting your MySQL password? Look no further! Here's a step-by-step guide for resetting your password on both Mac OS X and Ubuntu. Step 1: Stop MySQL sudo systemctl stop mysql…