Next Previous Up Contents
Next: HTML
Up: Supported Output Formats
Previous: Tab-Separated Table

4.1.2.9 SQL Tables

With appropriate configuration, TOPCAT can write out tables as new tables in an SQL-compatible relational database.

For writing, the location is specified as the following URL:

   jdbc:driver-specific-url#new-table-name

The exact form is dependent on the driver. Here is an example for MySQL:
   jdbc:mysql://localhost/astro1?user=mbt#newtab
which would write the current contents of the browser into a new table named "newtab" in the database "astro1" on the local host with the access privileges of user mbt.

Fortunately you do not have to construct this URL by hand, there is an SQL dialogue box to assist in putting it together.

Use of SQL queries requires some additional configuration of TOPCAT; see Section 10.3.


Next Previous Up Contents
Next: HTML
Up: Supported Output Formats
Previous: Tab-Separated Table

TOPCAT - Tool for OPerations on Catalogues And Tables
Starlink User Note253
TOPCAT web page: http://www.starlink.ac.uk/topcat/
Author email: m.b.taylor@bristol.ac.uk
Mailing list: topcat-user@jiscmail.ac.uk