Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • SELECT word FROM dict WHERE word IN ('aaaaa','bbbbb','ccccc',....)
    • This means I did not know SQL enough. Let me try it :)
    • It worked. THANK YOU!
      • I will (possibly) fail when the list of word in the 'IN'-clause gets long enough.
        I had problems with clauses longer than approx 100_000 in an old version of Ingres.

        The solution was to create a temporary table with all the words and then use this in the 'IN'-clause.

          CREATE TEMPORARY TABLE words(word VARCHAR(100));
          INSERT INTO words VALUES('aaaaa'); ....
          INSERT INTO words VALUES('xxxxx');
          SELECT word FROM dict WHERE word IN (SELECT word FROM WORDS);

        (SQl-code is suboptimal, but you

  • That's not complex, just big. I once did a 18 fold join: that is much more complex (without using views it wouldn't have been manageable).