Skip to main content

Posts

Showing posts from August 5, 2013

Linux tutorial Run crontab Every 10 Minutes

Each cronjob has following syntax: # +---------------- minute (0 - 59) # | +------------- hour (0 - 23) # | | +---------- day of month (1 - 31) # | | | +------- month (1 - 12) # | | | | +---- day of week (0 - 6) (Sunday=0 or 7) # | | | | | * * * * * command to be executed   To get crontab to run a task every 10 minutes you could type as follow */10 * * * * /path/to/command Once you set */10, the cronjob will be executed each time that the minute can be divided by 10 without remainder. etc 10/10, 20/10 30/10 using the same idea, you can divide the * by 2 3 or 59. If you wish to run every minute, just put To get crontab to run a task every minutes you could type as follow * * * * * /path/to/command To get this to work in Solaris, use the following example  0,10,20,30,40,50 * * * * /path/to/command

Cheap SanDisk Extreme SSD 480 GB SATA 6.0 Gb-s 2.5-Inch Solid State Drive SDSSDX-480G-G25

From the Manufacturer Give your laptop or PC a high-speed boost with the reliable SanDisk Extreme Solid State Drive (480 GB*). This drive is an ideal choice for gamers, video editors, and other users of graphic-heavy applications. Because the drive has no moving parts, it runs silently. It's also rugged, engineered to endure shocks and vibration for durability of the drive. The SanDisk Extreme SSD is a cost-effective way to upgrade your existing computer, and it consumes less power than a 7,200 RPM hard drive** to extend your laptop battery's life. * 1 gigabyte (GB*) = 1 billion bytes. 1 terabyte (TB) = 1 trillion bytes. Some capacity not available for data storage. Extreme Solid State Drive (480 GB*) At a Glance: Cost-effective upgrade solution for PC/laptop Fast read/write speeds ideal for gaming Quick boot-up/shutdown Resists shocks and vibration Uses less power than standard hard drives** No moving parts for quiet, cool operation Three-ye

SQL tutorial: Update multiple Column into one column using the same table

The point of this tutorial is to show you how to update multiple column into one column using the same table. Step 1 First you have to make sure that the select statement is correct, try to use the below example to see if your statement display the correct value. Example: select columnA||columnB from TABLE A; if you wish to include some kind of delimiter select columnA||', '||columnB from TABLE A; Step 2 Update TABLE A set column A = (select columnA||', '||columnB from TABLE A where A.index = B.index); Step 3 Once you are sure about your value, please commit the action. commit(); That is it! This conclude the tutorial on how to update multiple column into one column using the same table!