MySQL | Repair Table REPAIR command is used for repair a MySQL table REPAIR TABLE users We can also specify Quick and Extended after the table name REPAIR TABLE users QUICK If we specify Quick then MySQL will …

DATEDIFF function is use for finding the number of days between two given dates using MySQL DATEDIFF(‘2018-03-07′,’2017-01-01’)  

MySQL | Find the number of rows in a table We can use the below query to count the number of rows in a table >SELECT COUNT(*) FROM table_name;  

There are 5 different types of storage engine present in MySql. MyISAM Heap Merge INNO DB ISAM MyISAM is the default storage engine for MySQL

MySQL | What is the best collation to use for MySQL? Mostly we use: utf8_general_ci utf8_unicode_ci utf8_general_ci is used for fast sorting but it is less accurate whereas utf8_unicode_ci is used for better accuracy but …

The three different way in PHP to connect with MySQL is: MySQL MySQLI PDO Note: We should use MySQLI because MySQLI is imporoved version of MySQL and have more function then MySQL.