Manual doesn't describe output of "DESCRIBE tbl_name"
jwa...@mintel.com
Currently the manual contains circular references for "EXPLAIN tbl_name",
"DESCRIBE tbl_name" and "SHOW COLUMNS FROM tbl_name".
None of the relevant sections explains the output, they just refer you to
one of the other sections.
If the output of this command *is* described somewhere, it's well hidden,
as it can't easily be found from the TOC or by following the links in any
of the related sections.
>How-To-Repeat:
Look in the manual and try to find what "MUL" means in this table:
+-------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+---------+-------+
| id | int(11) | | PRI | 0 | |
| variant_type_id | int(11) | YES | MUL | NULL | |
| variant_type_name | varchar(64) | YES | MUL | NULL | |
| sql_statement | mediumtext | YES | | NULL | |
+-------------------+-------------+------+-----+---------+-------+
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Jonathan Wakely
>Organization:
Mintel International Group Ltd.
>MySQL support: none
>Synopsis: Manual doesn't describe output of "DESCRIBE tbl_name"
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: doc-bug
>Release: mysql-3.23.42 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.42, for -freebsd4.4 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.42
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 21 hours 43 min 5 sec
Threads: 130 Questions: 2398355 Slow queries: 18 Opens: 1838 Flush tables: 1 Open tables: 297 Queries per second avg: 30.675
>Environment:
System: FreeBSD juliet.mintel.co.uk 4.4-RELEASE FreeBSD 4.4-RELEASE #2: Fri Jan 11 11:38:03 GMT 2002 ja...@juliet.mintel.co.uk:/usr/src/sys/compile/JULIET i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 20010315 (release) [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='c++' CXXFLAGS='-O -pipe -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1205382 Sep 18 2001 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Oct 4 2001 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 572876 Sep 18 2001 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --with-berkeley-db --prefix=/usr/local i386--freebsd4.4
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thr...@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-myodbc=freebsd.csie...@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php