Jump to content

redRemedy

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

redRemedy's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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.
  2. 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
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.