techfolks mysql tutorials
Mysql Tips&Tricks

How to Get MySql Query Result as an Email

If you are working on a big mysql query and want to get the mysql query as email when it finishes use the below trick.

Go to mysql command:
Set pager directive:

mysql> pager mail -s “subject” emailme@domain.com
PAGER set to ‘mail’ -s “subject” emailme@domain.com

The trick uses pager directive to redirect the query output result to a mail program rather than displaying on mysql command.

Once above step is done, change database and run your query the query result will be emailed to the given email id

Related Articles

techfolks php tutorials logo
email filters in php PHP Tips&Tricks

How to Validate Emails Using Filters in PHP

viveik

Using PHP Filters we can fully validate an email id and this filter option requires PHP 5 version. Below is the code for validating emails in PHP using filters, along with using explode and foreach loop and then inserting the correct emails in the mysql database. Multiple emails validation. Validate Emails Using Filters in PHP

techfolks php tutorials logo
Excel Using PHP Excel Using PHP and Mysql Mysql PHP Sample Programs

Export to Excel Using PHP and Mysql

viveik

Below simple program will export mysql data values to excel sheet without using any PHP libraries. Export to Excel Using PHP and Mysql Note: IF you get errors or in excel all the data is in one column, then instead t tab space use, comma ‘,’.
Mysql

How to take Backup of MYSQL database sql file using MYSQLDUMP Command

viveik

For a single database: mysqldump –opt –user=root –password database1 > singledb.sql For multiple Backup of databases: mysqldump –opt –user=root –password –databases database1 database2 > multipledb.sql To import a MYSQL .sql file from one location to particular location : source /home/SSI/process_databases_backup.sql