On 25-Jun-2003 MaFai wrote:
> Hello, mysql,
>
> After create a table,it can use desc tablename to describe the table
> scheme.
> But it can not demonstrate that the column is unique or not.It just
> simplely show the column is MUL type.
> How can I get more information from the table by using mysql
> commend?(Except use mysqldump to read the sql file)
>
> or How can I type command to show the table structure?
> mysql>type some command
> mysql>create tabe
> //Show the specifing created table sql information
DESC tbl;
SHOW INDEX FROM tbl;
SHOW CREATE TABLE tbl;
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
