phpMyAdmin, the popular front-end to the MySQL database, has issued the first stable release of the version 3.0 series. The basic functionality remains unchanged, but there are some important differences. To begin with, phpMyAdmin 3.0 requires a minimum of PHP 5.2 and MySQL 5.0. Don’t try installing it with earlier versions of PHP or MySQL—it won’t work.
The main changes affecting the phpMyAdmin user interface concern the creation of new tables. They can be summarized as follows:
- When setting a default value for a column (field), you need to select a value from the drop-down menu. The options are
CURRENT_TIMESTAMP. If you select
As defined, type the default value you want the column to have in the field immediately below.
- As before, phpMyAdmin treats all columns as
NOT NULL. In other words, all columns require a value to be inserted in them. To make a column optional, select the
Nullcheckbox. In the version 2 series, this was a drop-down menu.
- To set an index on a column, choose the appropriate index type from the
Indexdrop-down menu. The choices are
FULLTEXT. In the version 2 series, these were represented by radio buttons.
- To create an auto incrementing column (normally used in conjunction with a primary key), select the
A_Icheckbox. In the version 2 series, this was a drop-down menu called