Author Archives: user

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 – 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 – 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 use; don”t define a field as 10 characters wide if you know you”re only going to use 2 characters. These types […]