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

PHP Mysql Visitor Counter Script
Mysql PHP PHP Scripts Sample Programs

PHP Mysql Visitor Counter Script

viveik

If you want to add a counter to a web page or a website then use the below simple PHP Counter Script using MySql. It is very easy to implement it and it counts whenever a page is being refreshed and the script won’t reduce page speed, unlike page counter scripts. PHP Visitor Counter Script […]

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 ‘,’.

techfolks mysql tutorials
delete duplicate rows duplicate rows duplicate rows in mysql duplicate rows in oracle sql mysql db2 find duplicate rows in sql get duplicate rows in sql how to get duplicate rows Mysql

How to find duplicate rows in Sql or Mysql

viveik

You can find duplicate rows in the mysql table, just use below select query, to find duplicate rows in Oracle, Sql, Mysql, DB2. SELECT columnName, COUNT(*) as countFROM selectedTableGROUP BY columnNameHAVING COUNT(*) > 1; You came from below query:how to find duplicate rows in sql server 2008how to find duplicate rows in sql and deletehow […]