"Point man is born. Simplicity, discipline is the wise man key." - by shamun

SQL cheatsheet.

My sql

SELECT x.a
FROM
( SELECT ’1′ AS a
UNION ALL
SELECT ’2′
UNION ALL
SELECT ’3′
) x
WHERE a NOT IN
( SELECT knr FROM table1 )

SELECT t.CHANNEL
, COUNT(*) / SUM(grp.TotalCount)
FROM my_table t
JOIN
( SELECT LOC_CODE
, COUNT(*) TotalCount — or is it perhaps?:
— COUNT(DISTINCT CHANNEL)
FROM my_table
GROUP BY LOC_CODE
) grp
ON grp.LOC_CODE = t.LOC_CODE
GROUP BY t.CHANNEL

My delete:

DELETE
FROM table
WHERE id IN
( SELECT id
FROM table
WHERE obsolete = 1
ORDER BY id
FETCH FIRST 100000 ROWS ONLY
)

Tizen Linux for mobile tablet smartphone will takeover the world. Backed by Intel, Samsung, Linux foundation. Good luck.

Tizen Linux for mobile tablet smartphone will takeover the world. Backed by Intel, Samsung, Linux foundation. Good luck.

- Android is less important in such case

- IPhone also

 

Sony use Linux? Sony ericsson has open source linux called “xperia”.

Giant Sony, Quality Sony uses finally Linux, never discovered by nobody ?

Sony ericsson: has there own operating system calls Xperia which is actually Android, before they were using Windows mobile platforms

Sony: themselves obviously is using Linux but they kept top secret, my guess is its either using JavaOS or Linux

- Great to know if somebody care to tell!

 

 

Ubuntu now runs in Android. Finally C programmers are happy to have there GCC back in the mobile battle.

Ubuntu is now running on top of Android. Soon there will be no more NDK/SDK requirement. Android made a mess mistake for GCC developers. Everything in past need to use NDK/SDK to retype every single lines to JNA code, which is idiot implementation actually of Android.

- Android Ubuntu will then allow GCC

- Tizen linux from Intel, Samsung will soon release there dragon Linux with GCC support to take-over Android, IPhone

 

NeBeans IDE 7.2 is almost ready. The Best IDE ever then Eclipse :)

NeBeans IDE 7.2 is almost in stable release. There was Github problem in the nightly release.

 

MySQL is 70x faster then before.

MySQL cluster has 70x speed.

www.melzoo.com – new search engine, like google, looks very nice and advanced

I was searching for nice results. And came to new search engine and started to use it now always, check it out www.melzoo.com

8-bit, 10-bit, 12-bit, 16-bit 24-bit, 32-bit video processing, video processing DVI HDMI SDI IP VGA. Working.

@TODO: Its all about color. And its all about pixel to micro pixel as RGB/YUV format.

How do i make sure my Linux operating system audio drivers are working. But hardware is defected for line in or mic in?

In my motherboard i have line in/mic in. But when i boot my linux i can not get audio in. I have tried all detectors but none is helping.

1. Get a speaker box or head phone

2. Put the head phone jack to the motherboard mic in/line in

3. Grab audacity software and knock your speaker you will see frequency

- if yes, Linux and its drivers are not the issue, culprit is the microphone+hardware

- if no, fix your audio libraries

 

How do i reduce my ATX chassis big computer machine to small unit?

I would like to minimize my system which is ATX power and has PCI-X1 slots. The size is huge, and that is problem, because its not handy and not friendly portable.

1. Buy mini-ITX power supply which has ATX jacks and 12V dc input

2. Buy PCI to PCI cable converter so that you can rotate horizontally (instead of default vertical)

3. Patch and hammer it

Big size is now reduced to small size.