Databases Reference
In-Depth Information
With the modified value list, the Insert panel now looks as follows:
Observe that the radio buttons have been replaced by a drop-down list because the
possible values are larger in length.
If we want more than one possible value selected, we have to change the column type
to SET . The same value list may be used. However, using our browser's multiple value
selector (control-click on a Windows or Linux desktop, command-click on a Mac), we
can select more than one value as shown in the screenshot:
In a normalized data structure, we would store only the genre code in
the topic table and would rely on another table to store the description
for each code. We would not be using SET or ENUM in this case.
DATE, DATETIME, and TIMESTAMP column
types
We could use a normal character column to store date or time information. But
DATE , DATETIME , and TIMESTAMP are more efficient for this purpose. MySQL
checks the contents to ensure valid date and time information, and offers special
functions to work on these columns.
 
Search WWH ::




Custom Search