| Entrance Reference Manual REPORT Syntax REPORT [report_series_type [, ...] ] [WITH] [TITLE "string"] ... [NOTE "string"] ... [MARGINS n] [NO HEADING] [NO BLANKLINE] [TABBED] [FONT font_family font_style font_size] SELECT (MySQL select statement body); The list of report series types, which can be omitted, specifies formats to use for columns in the report. Each report_series_type can be: AUTO | TEXT | SCIENTIFIC | PLAIN | PRINTF (format) | MONEY "AUTO" is the default and means "make a reasonable choice". Titles and Notes You can specify an unlimitted number of titles and notes. Titles are are left justified and go above the table. Notes are also left justified and go below the table. All of the text in a chart is report using a single font, which can be specified using the FONT keyword, which takes the form: FONT (family) (style) (size) "MONOSPACED", "SERIF" and "SANSSERIF" are available on all platforms as font families. Style can be "BOLD", "ITALIC" or "PLAIN". Size is the font size in points. Report settings "MARGINS" sets the number of blank spaces to leave for the left and right margin. "NO BLANKLINE" omits the blank line that normally precedes the first line in a report block. "NO HEADING" omits the column names and underline heading. "TABBED" specifies that table output should tab delimitted. Roadmap for 2.0 FIXEDWIDTH turns off padding and space between columns MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. Copyright (c) Tod Landis 2007 All Rights Reserved Modified: May 30, 2007 |
||