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…
MySQLi – Installation
Downloading MySQL The MySQLi extension is designed to work with MySQL version 4.1.13 or newer, So have to download MySQL. All downloads for MySQL are located at MySQL Downloads. Pick the…
MySQLi – Database Info
Obtaining and Using MySQL Metadata There are three types of information, which you would like to have from MySQL. Information about the result of queries − This includes the number of…
MySQLi – Using Joins
This is good enough for simple takes, but in most of the real world MySQL usages, you will often need to get data from multiple tables in a single query.…
- Go to the previous page
- 1
- …
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- …
- 183
- Go to the next page