SQL export

Description

This module allows direct export of the peak lists into MySQL or PostgreSQL database servers. If you would like to use another database then please add its JDBC driver (jar file) to the MZmine lib/ folder.

Method parameters

Peak lists (input)
Peak lists to be exported
JDBC connection string
Identification of the database according to the JDBC standard. For example:
jdbc:mysql://localhost/dbname?dbname=sqluser&password=sqluserpw
Database table
Name of the table for exported data
Export columns
The mapping between the database table columns (“Table column”) and MZmine data types (“Export data type”). For some data types an additional value (“Export value”) must be specified, such as for the “Constant value” type.