Count coloumns

[taffelman]

Hi

Is there an easy way to count how many coloumns a spesific table contains, and then also extract rhe coloumn headlines.

I need this to make a perl script wich automatic generates a HTML table based on the content of a MySql table.

TaffelMan

 

[QatQat]

Following command

show columns from table_name;

or

show fields from table_name;


do list all fileds in a table and give you the field count at the end.

I hope it helps


Bye



Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[QatQat]

The following command

show columns from table_name;

or

show fields from table_name;


do list all fileds in a table and give you the field count at the end.

I hope it helps


Bye



Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)