Hello,
@Mr. Price and Mr. Sims
Thank you for show me the way, your tips where very educational.
Thanks again.
--
Iván Alemán ~ [[ Debian (Sid) ]] ~
-BEGIN GEEK CODE BLOCK-
Version: 3.12
G!>GCM d+ s: a? C+++ UL++ P L+>+++$ E--- W++>+ N* o--- K- w O- M+ V--
PS++ PE-- Y PGP+>++ t-- 5 X R+
[...]
Is there any way to find out, using only plain SQL, the number of fields
of a given table.
describe gives me the number of fields as result, but I need to get only
that.
Is it possible?
Is it also possible to get only the fields name?
AFIK there's no easy way to accomplish this using j
y, September 22, 2006 10:54 AM
To: mysql@lists.mysql.com
Subject: Count Fields of a Table
Hello,
Is there any way to find out, using only plain SQL, the number of fields
of a given table.
describe gives me the number of fields as result, but I need to get only
that.
Is it possible?
Is it also possi
Hi David
If you are using mysql 5.0 and up, you can select from the
"INFORMATION_SCHEMA" database to get this information and much more.
Following is an example using a database called "test" and a table
called "t"
To get the column names, use
SELECT column_name FROM information_schema.co
Hello,
Is there any way to find out, using only plain SQL, the number of fields
of a given table.
describe gives me the number of fields as result, but I need to get only
that.
Is it possible?
Is it also possible to get only the fields name?
Thanks
David
--
MySQL General Mailing List
For li