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> […]
Category Archives: mysqli
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 […]
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 unless each individual operation within the group is successful. If any operation within the transaction fails, the entire transaction will fail. Practically, […]