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

SQL cheatsheet.

February 26, 2012 Leave a comment

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
)

Advertisements
Categories: MySQL

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

February 26, 2012 1 comment

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”.

February 26, 2012 Leave a comment

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.

February 26, 2012 Leave a comment

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 :)

February 26, 2012 Leave a comment

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

 

Categories: centOS, Fedora 12, PHP, Ubuntu, Zend

MySQL is 70x faster then before.

February 26, 2012 Leave a comment

MySQL cluster has 70x speed.

Categories: MySQL, Unix/Linux

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

December 20, 2011 Leave a comment

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

Categories: Ajax, cakePHP, Flash, HTML, IE, JavaScript, PHP, Zend