Transactions in MySql
Transactions are the block of statements that executes in a way that all statements execute […]
Advance MySql
Using EXPLAIN
MySQL comes with a powerful tool for investigating how the queries you issue to it […]
Ajax search suggestions using MySql and PHP
Following is the demonstration of how we can implement search suggestions from mysql database in […]
sort with order by first and then second
orderby clause of mysql may be used with one or more columns if we want […]
Select total number of rown in different tables
In order to show total number of rows in many table we use Information schema […]
Pagination of MySQL Query Results
As your database grows, showing all the results of a query on a single page […]
Using PHP Data Objects (PDO)
Connections are established by creating instances of the PDO base class. It doesn’t matter which […]
Character Sets and Collations
A character set is a set of symbols and encodings. A collation is a set […]
Range number of rows in MySql
MySql limit is used to range number of rows in a table to be displayed. […]