Counting in MySQL When Joins are Involved
There’s a MySQL pattern that I use fairly frequently that I want to share, both … Read More
MySQL Join
Summary: in this tutorial, you will learn various MySQL join clauses in the SELECT statement … Read More
How do I import an SQL file using the command line in MySQL?
Question I have a .sql file with an export from phpMyAdmin. I want to import … Read More
UPDATE Multiple Tables in MySQL Using LEFT JOIN
Question I have two tables, and want to update fields in T1 for all rows … Read More
MySQL LEFT JOIN Multiple Conditions
Question I have two tables: A and B linked by “group_id”. 2 variables I’m using: … Read More
How to Find the Second Highest Salary with MySQL Query
Hi! Today’s post is about a popular interview question, which is the sql query to … Read More
Dynamic Treeview Menu using PHP, MySQL and AJAX Example
How to Create Dynamic Treeview Menu using PHP, MySQL and AJAX? Most modern websites use … Read More
Per Table MySQL Database Backup Using PHP
One of the most important tasks any developer needs to do often is back up … Read More
Ordering by Specific Field Value First
Question I have a table with 3 columns: id | name | priority ——————– 1 … Read More
How to Find and Replace Data in MySQL
Recently, while migrating my blog, I had to find all the occurrences of my old … Read More
MySQL Ordering Results by Specific Field Values
In MySQL we can sort the results in ascending or descending order very easily by … Read More
Ordering by Specific Field Values with MySQL
There may be times when a specific order is required in a SQL query which … Read More
String Concatenation Done Right – Part 2 – An Effective Technique
Previously I have introduced string concatenation by demonstrating how not to use Transact-SQL to concatenate … Read More
SQL Concatenation Done Right – Part 1 – Dubious Practices
This article is a part of three articles series to explore SQL Concatenation techniques. Having … Read More