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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.