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 records affected by any SELECT, UPDATE or DELETE statement. Information about the tables and databases − This includes information pertaining […]
Category Archives: mysqli
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 . Pick the latest version number for MySQL Community Server you want and, as exactly as possible, the platform you want. Installing MySQL on Linux/UNIX […]
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 rapid random lookups and efficient ordering of access to records. While creating index, it should be considered that what are the columns […]