November 2008

How to count files (get the number of files) under a directory in Linux?

Just perform this command under the directory: find . -type f | wc -l and you will get the total number of files under it (recursively). Simply copy and paste that to do the trick. Or if you just need to count the files directly under the current directory: ls -f | wc -l Which …

How to count files (get the number of files) under a directory in Linux? Read More »

Using SQL to Find records existing in one table but not in another

The 2 tables are built with an identical data structure. Say you have records spread in both tables but neither of them are complete because both contain unique records. You need to consolidate the 2 tables into one with all unique records from each table. NOT EXISTS clause is just the way to do it …

Using SQL to Find records existing in one table but not in another Read More »

Scroll to Top