List foreign keys in mysql

By | September 5, 2009

information_schema The following query will list out the foreign keys in mysql. It finds it out from the information_schema database. select concat(table_name, '.', column_name) as 'foreign key', concat(referenced_table_name, '.', referenced_column_name) as 'references' from information_schema.key_column_usage where referenced_table_name is not null; The output is a clean table listing out all foreign keys from all databases +———————–+————-+ |… Read More »

PHP Format numbers to Indian Numerical System

By | July 1, 2009

The numerical system used in India differs from the Western system in terms of the placement of the thousands separator. Example : Number -> 1000000 Indian System -> 10,00,000 (Ten Lakh) Western System -> 1,000,000 (1 Million) While echoing numbers in PHP it is possible to format numbers with such separators using functions like number_format…. Read More »

Screen Resolution 1440 x 900 in Ubuntu

By | June 8, 2009

Ubuntu 9.04 did not detect the native resolution of my new LCD monitor which was 1440 x 900. Fix : 1. Get the modeline for the required resolution + refresh rate using the gtf command. desktop:~$ gtf 1440 900 75 # 1440×900 @ 75.00 Hz (GTF) hsync: 70.50 kHz; pclk: 136.49 MHz Modeline "1440x900_75.00" 136.49… Read More »