PHP MyAdmin
phpMyAdmin is one of the popular client software tools with an extraordinary user interface that helps to perform database handling operatio ...
MySQL - Category - Page 2
MySQL tutorials covering database design, queries, joins, indexing, and performance optimization. Focused on real-world usage in PHP and web applications.
Key Tutorials
All MySQL Tutorials
MySQL OrderBy
MySQL “ORDER BY” clause is used to order results based on a column. This clause is used in select queries to do sort by specifyi ...
MySQL Data Types
When we see PHP data types, we have listed a set of possible types of data with which the PHP variable may be initialized. Similarly, MySQL ...
MySQL Date Time
In MySQL, it includes set of date and time-related functions for performing manipulation over data that indicate the date, time or both. Usi ...
MySQL Fetch using PHP
PHP provides a huge list of MySQL functions to access the database from the front end. Among those functions, we are going to discuss some o ...
MySQL Right JOIN
Right, JOIN in MySQL is for the same purpose of getting columns from more than one table as like as MySQL Left JOIN we have seen some days b ...
MySQL Left Join
Left JOIN is one of the methods used in joining the database tables as we have seen in the introduction of MySQL JOINs. In this tutorial, we ...
Filtering MySQL Results by Applying PHP Conditions
In this article, we are going to discuss how to filter selected database rows based on the conditions applied using PHP. Let us have an exam ...
MySQL SHOW
In Mysql, SHOW command is used to get the details of database users and their privileges. Using this command we can show database and its ta ...
MySQL JOINs: An Introduction
MySQL JOINs are used to read data by connecting two or more related tables. While joining MySQL tables, we need to specify the condition for ...
Hi, I'm Vincy. I help build and improve PHP systems for eCommerce, payments, and legacy upgrades.
I'm available for freelance work.
Work with me