Next Previous Up Contents
Next: sqlupdate: Updates values in an SQL table
Up: sqlskymatch: Crossmatches table on sky position against SQL table
Previous: Usage

### B.20.2 Examples

Here are some examples of `sqlskymatch`:

    stilts -classpath lib/drivers/mysql-connector-java.jar \
           -Djdbc.drivers=com.mysql.jdbc.Driver
           sqlskymatch 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: sqlupdate: Updates values in an SQL table
Up: sqlskymatch: Crossmatches table on sky position against SQL table
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
Mailing list: topcat-user@jiscmail.ac.uk