Discuss MySQLi The MySQLi extension was introduced with PHP version 5.0.0 and the MySQL Native Driver was included in PHP version 5.3.0. i stands for improved in MySQLi and provides various functions to access the MySQL database and to manipulate the data records inside the MySQL database. You would require to call the MySQLi functions […]
Category Archives: mysqli
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. Let”s begin with creation of a table called tutorials_alter. root@host# mysql -u root -p password; Enter password:******* mysql> […]
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 indexes, default values, and so forth. You can handle this situation by following steps − Use SHOW CREATE TABLE to get […]