List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:September 18 2001 4:29pm
Subject:Re: table list
View as plain text  
At 9:08 PM +0530 9/18/01, Krushna Kumar R wrote:
>1. What command do i give to list all my databases

http://www.mysql.com/doc/S/H/SHOW.html

>2. what SQL statement do i give to list down all the tables existing 
>on the database

http://www.mysql.com/doc/S/H/SHOW.html

>3. what command or query do I give to display the structure of a 
>particular table

http://www.mysql.com/doc/S/H/SHOW.html

>
>Someone please help me with the above queries.

The MySQL Reference Manual is your friend.

>Thanx
>
>Regards
>Krushna Kumar


-- 
Paul DuBois, paul@stripped
Thread
table listKrushna Kumar R18 Sep
  • Re: table listPete French18 Sep
  • Re: table listPaul DuBois18 Sep