Techno-bits and some graphical adventures of my life

Problem: How to delete all tables in a mysql database. Solution: One solution can be, you can drop the whole database or run the query written below do avoid deleting the database. SET FOREIGN_KEY_CHECKS = 0; SET GROUP_CONCAT_MAX_LEN=32768; SET @tables = NULL; SELECT GROUP_CONCAT(table_name) INTO @tables FROM information_schema.tables WHERE table_schema[…]

Its 3:20 a.m. in the morning and I have flight to catch at 6:15 in the morning. I have called my cab at 4:15 a.m., old trusted Meru Cabs. I have been using Meru Cabs for all my travel/airport pickup and drop needs since i came to Delhi. They are[…]

Recently, while checking the e commerce overview on google analytics i got the message on some reports in red background. “Multiple decimal separators in pattern “Rs.###,##0.##”×” This is a bug in google analytics. The google analytics appends . after Rs symbol which causes some parsing problems on generating reports. The[…]

Random Web

Three layers of web

Long back people used to (they still, out of unawareness or laziness) write their HTML, CSS, Javascript code in single file. But soon they realized that the code they write can be divided into three fundamental layers: Content Layer – HTML Presentation Layer – CSS Behavior Layer – Javascript Keeping  your[…]