Category: Mysql

  In case our application would be spread world wide ,the  timezone variation issue is very common in database world. The below example depicts how to set mysql database timezone to Asian time.                  SET GLOBAL time_zone = ‘+5:30’;                SET GLOBAL time_zone = Asia/Calcutta;    

To remove duplicate value from the table is very simple. if it has primarykey that make more convenient. The below query shows how to delete duplicate with maximum value.    delete         from db.task_table         where taskId in (         select * from (                     select        … Continue reading how to remove duplicates value in database table

Way 1 ===== The following syntax used to shows field name ,datatype with all constraints . SHOW COLUMNS FROM table_name FROM database; Way 2 ===== In this case , it shows the column name with ascending order . SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = ‘table_name’ AND table_schema = ‘database’     ORDER BY column_name;