PHP/MySQL : Creating a MySQL Table
Jean-Guillaume Birot
Data Input
Are you still on the confirmation screen? Fine. Then click on the link which reads your base name located at upper left of
the page, in order to return to
the main page. This latter indicates that there is now a table in your database. Click on the link
Insert to access
the input form.
Here are a few useful details regarding data input:
- The id column is auto-incremented. So no value needs to be entered.

- Columns of the ENUM type propose their valid values through a drop-down list in order to avoid mistakes.

- The Functions column allows you to use built-in MySQL functions to calculate values. For instance, the NOW function can be used to assign the current date to the Date column.

You can now create your first article by entering the corresponding values in the various table columns. Validate it by clicking
on
Save. Repeat these steps for all the articles you want to create.
To view your articles, click on
Browse from
the main page. You can see all your articles displayed in a table. Through the
Edit link, to the right of each article's columns, you can change any article by reverting to the input form.