35.4. Creating a New Table

Tables can be added to newly created or existing databases at any time. Every table has one or more fields, each of which has a type (such as integer, decimal, or text) and a size. Fields can also be indexed to speed up SQL queries that look up records based on the values in that column.

To add a new table to a database, follow these steps:

1.
On the module's main page, click on the database icon. This will bring you to the database editing page shown in Figure 35.2 that contains an icon for each existing table and buttons for performing various actions.
Figure 35.2. The database editing page.

2.
Enter the number of ...

Get Managing Linux® Systems with Webmin™ System Administration and Module Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.