Tutorials Archive

MySql – Sorting a column containing string with numbers

Sorting a column containing string with numbers If you have wondered how can you sort a column which contains a combination of string and number, please have a look at the following example. name ==== string12 string124 string1 string342 string9 If you want the display output to be as follows: name ==== string1 string9 string12

Find all tables containing a specific column

If you have wondered how can you get all the table names which contains a specific column, here is a simple SQL query which does the same. select column_name, table_name from information_schema.columns where column_name like "%mycolumname%"; or select column_name, table_name from information_schema.columns where column_name = "mycolumname";

Installing JSLint On Ubuntu For Command Line Use

What is JSLint? JSLint is a JavaScript program that looks for problems in JavaScript programs. It is a code quality tool. JSLint takes a JavaScript source and scans it. If it finds a problem, it returns a message describing the problem and an approximate location within the source. The problem is not necessarily a syntax

Bit Depth Vs. Bit Rate

Bit depth and Bit rate, you might think that these two similar. They are however, two completely different. Bit rate describes the speed that sound data is played back. For example : A 120 Kbps MP3 song will process at 120, 000 bits per second A 320 Kbps MP3 song will process at 320, 000

How fix app UI while upgrading ios6 to ios7 with a single line of code

A sample application UI in iOS6 A sample application UI in iOS7 before applying the fix given below A sample application UI in iOS7 after applying the fix given below Add following code to viewDidLoad make support for iOS6 and iOS7 for nib and programmatic code: self.edgesForExtendedLayout = UIRectEdgeNone; self.automaticallyAdjustsScrollViewInsets = NO;

Encrypt and Decrypt files with ccrypt

In GNU/Linux, there are decent amount of tools with graphical interfaces that make file encrypting a breeze. However, there are also command-line based ones (few!) that let you easily encrypt/decrypt your data as well. Other than not having the ability to use the mouse (plus if you’re not a touch typist), most people don’t like

How to Check your Internet Usage for Airtel Broadband

How do I check Airtel Broadband connection usage? How do I check my high speed data transfer limit? How do I find out how many GBs are left in my airtel account? You can easily check your Airtel Boardband connection usage using the following steps: Click here to check your Airtel Broadband usage. Which don’t