1, native column commenting is supported. The good news is that
for any MySQL version, column commenting via phpMyAdmin is always accessed
via the Structure page by editing each field's structure. In the following example, we
need to comment three columns, so we choose them and click the pencil icon:
To obtain the next panel as seen here, we are working in vertical mode by setting $cf
g['DefaultPropDisplay'] to 'vertical'. We enter the following comments:
isbn: book number
page_count: approximate
author_id: cf author table
Then we click Save.
??? ??? ???
Chapter 11
[ 193 ]
These comments appear at various places??”for example, in the export file
(see Chapter 7), on the PDF relational schema (see Chapter 15), and in the
Browse mode:
If we do not want the comments to appear in Browse mode, we can set $cfg['ShowB
rowseComments'] to FALSE. (It is TRUE by default.)
Column comments also appear as a tool tip in the Structure page, and column names
are underlined with dashes. To deactivate this behavior, we can set $cfg['ShowProp
ertyComments'] to FALSE. (This one is also TRUE by default.)
Automatic Migration
Whenever phpMyAdmin detects that column comments were stored in its metadata
and that we are using MySQL 4.1.2 or a later version, it automatically migrates these
column comments to the native MySQL column comments.
Pages:
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190