SQL Queries Examples

Here follow examples that will help you to figure out how external database can be accessed.

Access to MySQL (DBD::mysql is used)
Here Indexsoft Intuitive Mailer uses it's own tables to retrieve a list of users. Make sure you specify correct MySQL database name, MySQL host, username and password if you wish to test this example.

data source, username and password:
"DBI:mysql:database=intuitive;host=localhost","root",""

SQL query:
select uname, uemail from _iml_users

Access to dbf file (DBD::Xbase is used)

data source, username and password:
"DBI:XBase:/www/home/dir/dbfs/"

SQL query:
select name, email from subscr

Access to ODBC (DBD::ODBC for windows is used)

data source, username and password:
"DBI:ODBC:database"

SQL query:
select name, email from subscribers