GettingStarted

Getting Started

A Quick Tour

When Entrance is first connected, your window will look like this:

The explorer tree contains connection nodes, named "root" and "anonymous" in the example above, and other kinds of nodes. Expand a connection node, by clicking the triangle next to it, and you will see MySQL databases. Expand a folder node and you will see files.

A right click on any node (Control-click on a Mac) brings up its popup menu.

Opening a SQL script and running it

Entrance creates one folder node for saving SQL scripts, named "sql", automatically when it is installed. You can create more with the File | Add Folder... menu pick. You can also drag and drop files to and from the folder from your system's file explorer.

Expand the sql folder now, and double click on the script "createTenElements.sql" to open it.

Notice that the exclamation point on the toolbar "Run" tool changed to green. When it is green, it means you have a SQL script ready to run. Clicking the "Run" tool or use the File | Run menu selection to run it.

Try running the script now. When you do, it will create a table named "TenElements" and then display data from it:

You can jump back and forth between viewing the SQL script or viewing the results it generates by clicking on the "SQL" and "Results" tabs at the bottom of the window.

Opening a table

Double click on the table "TenElements" to open it, and you will see the "Table View" of TenElements:

Both the table and the SQL script are now open, and you can jump back and forth between them by clicking the tabs labeled "createTenElements" or "TenElements".

Query a table

There is a quick way to make a SELECT query for any given table. Right-click (or control-click) its icon, then select "SQL to SELECT *" from its popup:

This will create a new query for selecting all elements in table "TenElements". Try running it by clicking the Run tool

Saving queries

Navigate back to the SQL tab for the new query you created, which will be named "query1", and then click the "Save" tool on the toolbar. Name the new query something, and click OK.

Now look in the "sql" folder, and there is the query.

There are keyboard shortcuts for saving queries, and the File menu will show you what they are for your system.

Make a blank script

Use the "New" tool to start with a blank scripts. Each time you click New it will create a new blank script tab.

Closing scripts and tables

To close scripts and tables use the Window | Close this tab menu selection, which has a shortcut key. Check the menu to see what the shortcut is on your system.

To continue learning about Entrance, read "Creating Database Tables", "Making Reports" or "Charting Data With Entrance"

Please note: This web page and other Entrance documentation web pages are copyrighted material and have not been released under the terms of the GPL.

Java and the Java Coffee Cup Logo are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries. Solaris is a trademark of Sun Microsystems, Inc. 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.