Making Charts
You can make a chart starting from a database table or starting from a SQL SELECT statement in a query script.
Starting with a SELECT statement
To make a chart starting with a SELECT statement, include the PLOT keyword before it and then describe the chart you want drawn using PLOT syntax. For example:
PLOT
axislabels, red line
SELECT
day, value from mytable;
Plot commands consist of two parts: a chart description part and a “SELECT” part, which can be any MySQL SELECT command.
Chart series should match up 1-to-1 with columns in the result set from your SELECT command. You can also add things like titles and legends this way:
PLOT
axislabels, red line
WITH
TITLE “Title”
TITLE X “X Title”
TITLE Y “Y Title”
LEGEND BOTTOM
GRIDLINES
SELECT
day, value from mytable;
There are more examples in the Visual Guide to Entrance PLOT Syntax and in the download file charts.zip. The complete PLOT syntax is in the Help menu.
Starting with a database table
When you have a table displayed you can use the Charts menu to make charts:
which provides dialogs for making charts like this one:
Copyright (c) 2008 dbEntrance Software, All Rights Reserved
MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. Windows is a trademark of Microsoft Corporation. Macintosh is a trademark of Apple Computer, Inc.