From: Michael Widenius
Date: May 21 2002 4:37pm
Subject: Wish List -- Make  SHOW compatible/symmetrical  with SELECT
List-Archive: http://lists.mysql.com/internals/3641
Message-Id: <15594.30693.99934.266756@gargle.gargle.HOWL>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Hi!

>>>>> "Erik" == Erik Perrhoe <\(Computer Consultant\)" <mysqllist@stripped>> writes:

Erik> Greetings!
Erik> Apologies in advance if I have sent this to the wrong list.

<cut>

Erik> My wish would be for the following to work:

Erik> SHOW  status WHERE Value > 0

This is planed for MySQL 4.1 or MySQL 5.0

Erik> and also

Erik> CREATE TEMPORARY TABLE foo ( Variable_name VARCHAR(255), Value DOUBLE )
Erik>  SHOW status

The above is not yet planned, but thanks for the idea.

Erik> and especially

Erik> INSERT INTO foobar  SHOW COLUMNS FROM aTable

Same comment as above.

Regards,
Monty

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Michael Widenius <monty@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
       <___/   www.mysql.com