Most Used Categories

Databases , Learn MySQLi

MySQLi – Handling Duplicates

MySQLi – Handling Duplicates, Tables or result sets sometimes contain duplicate records. Sometimes, it is allowed but sometimes it is required to stop duplicate records. Sometimes, it is req…Read More

Databases , Learn MySQLi

MySQLi – Clone Tables

MySQLi – Clone Tables, There may be a situation when you need an exact copy of a table and CREATE TABLE … SELECT doesn’t suit your purposes because the copy must include the same in…Read More

Databases , Learn MySQLi

MySQLi – Using Sequences

MySQLi – Using Sequences, A sequence is a set of integers 1, 2, 3, … that are generated in order on demand. Sequences are frequently used in databases because many applications require…Read More

Databases , Learn MySQLi

MySQLi – Indexes

MySQLi – Indexes, A database index is a data structure that improves the speed of operations in a table. Indexes can be created using one or more columns, providing the basis for…Read More

Databases , Learn MySQLi

MySQLi – Temporary Tables

MySQLi – Temporary Tables, The temporary tables could be very useful in some cases to keep temporary data. The most important thing that should be known for temporary tables is that they …Read More

Databases , Learn MySQLi

MySQLi – Regexps

MySQLi – Regexps, You have seen MySQL pattern matching with LIKE …%. MySQL supports another type of pattern matching operation based on regular expressions and the REGEXP opera…Read More

Databases , Learn MySQLi

MySQLi – Transactions

MySQLi – Transactions, A transaction is a sequential group of database manipulation operations, which is performed as if it were one single work unit. In other words, a transaction wi…Read More

Databases , Learn MySQLi

MySQLi – ALTER Command

MySQLi – ALTER Command, MySQL ALTER command is very useful when you want to change a name of your table, any table field or if you want to add or delete an existing column in a table.…Read More

Databases , Learn MySQLi

MySQLi – Sorting Results

MySQLi – Sorting Results, We have seen the SQL SELECT command to fetch data from a MySQL table. When you select rows, the MySQL server is free to return them in any order, unless you ins…Read More