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 required to identify duplicate records and…
MySQLi related blog…
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 each row…
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…
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 will be…
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 both…
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…
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 will never be complete…
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 operator. If you are aware of PHP or PERL,…
MySQLi – Data Types
Properly defining the fields in a table is important to the overall optimization of your database. You should use only the type and size of field you really need to…
MySQLi – Administration
Running and Shutting down MySQL Server First check if your MySQL server is running or not. You can use the following command to check it − ps -ef | grep…