SQL & Others

Welcome to a short tutorial on how to measure the time taken to execute a query in MYSQL. So just how long did a query take to run in MYSQL? Which query is better and faster? There are several ways to measure and benchmark queries in MYSQL: The simplest way is to run the query […]

Welcome to a quick tutorial on how to set Chrome into kiosk mode. Yes, there is a hidden gem called “kiosk mode” in Google Chrome that not many developers know of. It is but a very simple mechanism to set Chrome to full-screen incognito and remove all navigation bars. That is, we can easily point

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

Welcome to a quick guide on the differences between server-side and client-side scripts. Have you just started with web development or interested to learn more? Scripts that run on the user’s device are called “client-side scripts”. Generally less secure because users have direct access to the scripts. Usually deals with the user interface – Show

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),

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

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

Welcome to a tutorial and examples on how to do MySQL search queries. Yes, this is a very common question and pitfall among beginners. How difficult can a SELECT query be? Not so straightforward, apparently. There are 3 common ways to do search queries in MySQL Exact match search (get all records that match the

Welcome to a tutorial on how to import SQL files. So you have downloaded an SQL file from the Internet, and don’t know how to import it? There are 3 common ways to import an SQL file into MYSQL: Run mysql -u USER -p DATABASE_NAME < PATH/TO/FILE.sql in the command line (or terminal). Use MySQL

Welcome to a sharing of an ERD for a simple feedback system. So you are working on a system to capture feedback from students, customers, patients, or whoever else? Well, here is a quick sharing of my version – Read on!     TABLE OF CONTENTS ER Diagram Table Structure Extras The End   ER