[testing server]

If you use the phpMyAdmin on both your local test machine and your production server, you will find that there is several exporting options for you to choose from. phpMyAdmin also offers an online documentation.

[SubQuery seems to hang MySQL]

Hi!

I am currently evaluating MySQL version 4.1.21. Until now I have only used versions without the support of SubQueries.

As my first test I was planning to re-make som existing queries into Sub-queries. So I started with the following query:
[code]SELECT p.*
FROM
s24_event e, s24_event_participant ep, s24_participant p
WHERE
ep.event = $pEventId
AND e.id = ep.event
AND p.id = ep.participant
[/code]

and I changed it into this:
[code]
SELECT *
FROM s24_participant
WHERE id IN
(
SELECT participant
FROM `s24_event_participant`
WHERE event = $pEventId
)
[/code]


I should get the same result from these two queries, right?

The latter one seems to cayse MySQL to stop responding. WHen I ran it through a PHP-script I got the "Too many connections"-error message.

Does anyone have any ideas of what the problem could be?

// Jonas Eriksson