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 mysql tutorials
Mysql

MySQL Offset Limit Data Selections

viveik

MySQL provides a LIMIT clause that is used to specify the number of records to return. The LIMIT clause makes it easy to code multi page results or pagination with SQL, and is very useful on large tables. Assume we wish to select all records from 1 – 30 (inclusive) from a table called “Orders”. […]
Blogger General Tips&Tricks

How to Remove Navigation bar in Blogger

viveik

To remove nav bar on the top of a blogger blog simply follow below steps: For New Blog Interface : Sign into blogger, now it will show list of your blogs now click  on this icon  and click on template. Now click on Edit HTML Tab. You will get a warning page avoid and click on […]

techfolks mysql tutorials
Mysql

How to Add Column to Mysql Table and Auto Increment with Primary Key

viveik

Check below on How to Add a Column to Mysql Table with Auto Increment and Primary Key You can achieve it by doing Alter Command: Add Column to Mysql To Modify Column and add Auto Increment with Primary Key Query: ALTER TABLE test MODIFY COLUMN ID INT(10) PRIMARY KEY  auto_increment; ALTER TABLE users ADD id […]