![]() |
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