Tips & Tutorials – SQL & Others

Get & Count Duplicate Records In MYSQL (Simple Examples)

Welcome to a quick tutorial on how to get and count duplicate records in MySQL. So you want to filter out all the duplicate records? Or maybe get a count of the number of duplicates? Assuming that only one table and column are involved, duplicate records can be retrieved with a simple query – SELECT …

Get & Count Duplicate Records In MYSQL (Simple Examples) Read More »

MYSQL Calculate Difference Between 2 Dates (Simple Examples)

Welcome to a quick tutorial and examples on how to calculate the difference between dates in MYSQL – In minutes, days, months, and years. Yes, these are probably the most common questions. How to calculate the difference between 2 dates? How to add or minus days? How many days have passed till today? Let us …

MYSQL Calculate Difference Between 2 Dates (Simple Examples) Read More »

What is WAMP LAMP MAMP XAMPP (Plus Their Differences)

Welcome, and you are probably here because of the confusion between WAMP, LAMP, MAMP, and XAMPP. Techies sure like to abbreviate everything, just what the heck do these mean? For a quick answer: WAMP – Windows, Apache, MySQL, PHP LAMP – Linux, Apache, MySQL, PHP MAMP – Mac, Apache, MySQL, PHP XAMPP – Cross-platform (X), …

What is WAMP LAMP MAMP XAMPP (Plus Their Differences) Read More »

9 Types of Computer Programmers (And What They Do)

Welcome to a guide and list of the different types of computer programmers. Digital devices and automation are everywhere in this age, and programmers are in huge demand. Maybe you are interested in the job called “programmer”? Or maybe you are just curious? To keep the story short, “programmer” is a very generic title these …

9 Types of Computer Programmers (And What They Do) Read More »