The MySQL DISTINCT operator returns only unique values from a column from a database table; duplicates are not returned. Here’s how to use it. The DISTINCT operator can be useful in many scenarios; for example, you may want to generate a list of countries you have… Read More »The MySQL/MariaDB ‘DISTINCT’ Statement, With Examples
MySQL (and its functional equivalent, MariaDB) have two things named TRUNCATE – so watch out which one you want to use or suffer dire consequences! This article outlines the difference and usages of the MySQL TRUNCATE function and TRUNCATE TABLE statement – they share similar names but do very different things.… Read More »The MySQL (and Maria DB) TRUNCATE Command, With Examples (And Warning!)
This article explains JavaScript and Node.js and their relationship with each other. What is JavaScript? JavaScript has become one of the most popular programming languages for building web applications and has even become a contender for building solid desktop and mobile applications. In the browser,… Read More »The Difference Between JavaScript and Node.js – Which Should I Use?
Both Python versions 2 and 3 provide several helpful string methods that let you find the string’s contents. Here’s how to use them. The functions in this article are useful if you want to validate user input – for example, you may want to check that… Read More »isdigit(), isalpha() and Other Checks in Python, With Examples
This article will show you how to round numbers up, down, and to the nearest 1, 10 100 (or any number) in the Python programming language. Truncation vs. Rounding Truncation isn’t technically rounding, but it serves a similar purpose, so I’ll include it here. It’s… Read More »How to Round Numbers Up/Down/Nearest in Python
This article will outline several methods which can be used to check that a file exists/is readable in the Python programming language. You may wish to check whether a file exists before reading or writing to it to reduce the number of alerts you need to… Read More »Checking If A File Exists in Python, With Examples
The PHP parse_url() function processes a given URL and divides it into its individual components. Here’s how to use it. parse_url() is often used to get the host/domain name from a given URL or the path to a remote host file. Syntax for parse_url() parse_url ( $url… Read More »How to use the PHP parse_url() Function, With Examples
The ‘this‘ keyword in JavaScript is a confusing concept for some – the meaning of ‘this‘ changes based on context. This article explains what ‘this‘ is. What is Object-Oriented Programming Object-Oriented Programming is a way of structuring your code so that data is organized into objects. JavaScript supports… Read More »What is the ‘this’ Keyword in JavaScript (Object-Oriented Programming)
This article explores several ways to remove duplicate items from lists in the Python programming language. Using The dict.fromkeys() Method To Remove Duplicates From a List in Python This is the fastest way to remove duplicates from a list in Python. However, the order of the… Read More »How to Remove Duplicates From a List In Python, With Examples
This article shows you how to use the PHP isset() function to check whether a variable exists and is populated. So, it’s checking if a variable is set. Why would you want to do this? You can’t perform actions on a variable that doesn’t exist or that has… Read More »PHP isset() – Check if A Variable is Set, With Examples