Databases Reference
In-Depth Information
And the next one represents the right side:
The MySQL documentation explains valid characters for the table and column names
(if we search for "Legal names"). This may vary depending on the MySQL version.
Usually, any character that is allowed in a file name (except the dot and the slash) is
acceptable in a table name, and the length of the name must not exceed 64 characters.
The 64-character limit exists for column names as well, but we can use any character.
We enter our column names under the Column column. Each column has a type, and
the most commonly used types are located at the beginning of the drop-down list.
The VARCHAR (variable character) type is widely used when the column content
is alphanumeric, because the contents will occupy only the space needed for it.
This type requires a maximum length, which we specify. If we forget to do so, a
small pop-up message reminds us later when we save. For the page count and
the author identification, we have chosen INT type (integer), as depicted in the
following screenshot:
 
Search WWH ::




Custom Search