techfolks mysql tutorials
Current Timezone of database Current Timezone of mysql Current Timezone of mysql database Current Timezone of mysql server Mysql mysql timezone query

How to Get the Current Timezone of Mysql Database

By running below query you can able to get the Current Timezone of the database server.

select timediff(now(),convert_tz(now(),@@session.time_zone,’+00:00′));

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”. […]

techfolks mysql tutorials
db size query Mysql Mysql database query query to get db size

How to Get Size of a Database in Mysql

viveik

To Get Data Base Size in MB  and Free Space in MBSELECT table_schema “dbName”,    sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB”,    sum( data_free )/ 1024 / 1024 “Free Space in MB”FROM information_schema.TABLESGROUP BY table_schema ; To Get Size in GB: SELECT  sum(round(((data_length + index_length) / 1024 […]

techfolks mysql tutorials
Mysql Tips&Tricks

How to Get MySql Query Result as an Email

viveik

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.comPAGER set to ‘mail’ -s “subject” emailme@domain.com The trick uses pager directive to redirect the query output result to […]