Prev | Current Page 201 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"

Alternatively, we could click the pencil icon to open the Edit page for a
specific row, so that we can see the query's complete text.
Summary
In this chapter, we saw how to record bookmarks (after or before sending a query),
how to manipulate them, and how some bookmarks can be made public. We learned
about the default initial query for Browse mode. We also covered passing parameters
to bookmarks and executing bookmarks directly from the pma_bookmark table.
System Documentation
Producing and maintaining good documentation about data structure is crucial for a
project's success, especially when it's a team project. Fortunately, phpMyAdmin has
features that take care of this. When phpMyAdmin generates results, there is always
a Print view link that can be used to generate a printable report of the data. The Print
view feature can also be used to produce basic documentation, and this is done in
two steps. The first click on Print view puts a report on screen, with a Print button at
the end of the page. This Print button generates a report formatted for the printer.
The Database Print View
Clicking Print view on the Structure sub-page for a database generates a list of
tables. This list contains the number of records, storage engine, size, comments, the
dates of creation, and last update for each table.
System Documentation
[ 230 ]
The Selective Database Print View
Sometimes, we prefer to get a report only for certain tables.


Pages:
189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213