MySQL - Category

MySQL tutorials covering database design, queries, joins, indexing, and performance optimization. Focused on real-world usage in PHP and web applications.

All MySQL Tutorials

MySQL Database Files

In MySQL database installation, a directory has a set of files that contain database metadata and data. That is the database schema and cont ...

November 28th, 2013

MySQL vs MySQLi in PHP

MySQL and MySQLi are PHP database extensions implemented by using the PHP extension framework. PHP database extensions are used to write PHP ...

October 30th, 2013

Update/Delete Multiple Rows using PHP

We are well expertise with PHP CRUD operations by accessing MySQL via PHP logic. Yet, we have seen how to update and delete table rows one a ...

September 23rd, 2013

PHP CRUD with MySQL

In this tutorial, we are going to see an example program to learn how to do database CRUD operations using PHP and MySQL. CRUD tends to Crea ...

September 6th, 2013

MySQL CONCAT

For MySQL, there are several inbuilt functions, that could be used while writing queries. We have seen some of them, like, MySQL datetime fu ...

August 30th, 2013

↑ Back to Top