Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

  • RE: Efficiently Searching Database

    This seemed to work

    delimiter //

    CREATE PROCEDURE pokerranks2.GetRanks(

    IN deckForm INT)

    BEGIN

    SELECT rank0, rank1, rank2, rank3, rank4, rank5 FROM ranks WHERE deckForm = deckForm;

    END;

  • RE: Efficiently Searching Database

    I've tried removing that and doing everything possible to it but I get the same error message every time

  • RE: Efficiently Searching Database

    Thanks a lot for your reply.

    Here is what phpMyAdmin shows for Indexes:

    PRIMARYBTREEYesNodeckForm2602455A

    idBTREEYesNodeckForm2602455A

    id_2BTREENoNodeckForm2602455A

    deckFormBTREENoNodeckForm2602455A

    The Create Procedure sounds like it will help a lot. Every time I try it though...

Viewing 3 posts - 1 through 4 (of 4 total)