35.7. Viewing and Editing Table Contents

The MySQL module allows you to view the contents of any table in any database. Tables that have a primary key can have their records modified or deleted and new ones added as well.

Table 35.1. MySQL Field Types and Their Uses
TypeDescription
intStores a single integer, which can be signed or unsigned. An int field can, at most, store numbers in the range –231 to +231, but this can be further restricted by specifying a maximum number of decimal digits when the field is added.
tinyintLike an int, but only numbers in the range –128 to +127 can be stored.
smallintLike an int, but only numbers in the approximate range –32768 to +32767 can be stored.
mediumintLike an int, but only numbers in the approximate range ...

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.