Next Previous Up Contents
Next: tcat: Concatenates multiple similar tables
Up: sqlcone: Crossmatch between local table and table in SQL database
Previous: Usage

A.5.2 Examples

Here are some examples of sqlcone:

stilts -classpath lib/drivers/mysql-connector-java.jar \
       -Djdbc.drivers=com.mysql.jdbc.Driver 
       sqlcone in=messier.xml ra=RA dec=DEC sr=0.05 \
               db='jdbc:mysql://localhost/ASTRO1' user=mbt \
               dbtable=FIRST dbra=_RA2000 dbdec=_DE2000 \
               out=matches.xml
This performs a series of SELECT statements on the table FIRST in the local MySQL database ASTRO1 to identify database objects in the region of each object represented in the VOTable messier.xml. The result, a join between the Messier and FIRST tables, is output as a VOTable called matches.xml. In this case a password has not been supplied on the command line, so if one is required it will be prompted for on the console.


Next Previous Up Contents
Next: tcat: Concatenates multiple similar tables
Up: sqlcone: Crossmatch between local table and table in SQL database
Previous: Usage

STILTS - Starlink Tables Infrastructure Library Tool Set
Starlink User Note256
STILTS web page: http://www.starlink.ac.uk/stilts/
Author email: m.b.taylor@bristol.ac.uk