2 messages in com.mysql.lists.win32Re: handler command
FromSent OnAttachments
Saqib Ilyas16 Apr 2002 22:05 
Paul DuBois18 Apr 2002 14:37 
Subject:Re: handler command
From:Paul DuBois (pa@snake.net)
Date:04/18/2002 02:37:35 PM
List:com.mysql.lists.win32

At 5:05 +0000 4/17/02, Saqib Ilyas wrote:

Hi ppl I downloaded mysql latest version 3.23.49 and even downloaded the source and compiled it. I even tried 4.0.1. The problem I am having is with the handler command. I run it in the mysql utility, it refuses the command and complains that there is an error in the command. It just doesnt accept the command at all. I searched the code for mysql and it doesnt expect to hear a handler command. I issued the command from my own client program written in Visual C++ using the C api and it runs successfully but doesnt return anything at all. No results. Is there an issue with this command implementation on windows, or is it treated differently than other SQL queries? Thanks

Works for me. Please show us the exact commands that you're trying. One other thing that might be a problem is if you're not using MyISAM tables. (HANDLER works only for the MyISAM table handler.) I'm guessing that's not the problem, though. From your description it sounds more like a syntax error.