How to french kissing

http://www.videojug.com/film/how-to-kiss-someone-passionately
http://www.5min.com/Video/Learn-different-kinds-of-kisses-1279

Error:1235- This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

If you try the following you will find it fails in mysql version 4.1,

SELECT
COUNT(*)
FROM
TABLE_1
WHERE
ROW (PK_PART_1, PK_PART_2) IN
(
SELECT
PK_PART_1, PK_PART_2
FROM
TABLE_2
LIMIT
10 -- This is the basis of the whole idea
)
AND
Whatever;

The above fails with the warning ...

ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

However, you can get the desired behaviour with a slight rewrite...

SELECT
COUNT(*)
FROM
TABLE_1
INNER JOIN
(
SELECT
PK_PART_1, PK_PART_2
FROM
TABLE_2
LIMIT
10 -- HEY HEY!
) AS VIRTUAL_TABLE_2
ON
TABLE_1.PK_PART_1 = TABLE_2.PK_PART_1 AND
TABLE_1.PK_PART_2 = TABLE_2.PK_PART_2
WHERE
Whatever;

And it works like a charm!

Swap in Linux

Had a swap space allocated but it was not mounted as so, and my computer had regular memory problems.

So what I did was,

• checked the swap partition first
• added the entry in /etc/fstab file as
• /dev/sda3 none swap sw 0 0
• sudo swapon -a
• checked by using cat /proc/swaps and it was found the following
• /dev/sda3 partition 1052248 423616 -1