Try mysql_info, mysql_type, mysql_type_name

All of these are in the docs.  Please see.

Ilya Sterin

------Original Message------
From: Michael Cheung <vividy@[...].jp> 
To: Dbi-Users <dbi-users@[...].org> 
Sent: October 20, 2000 1:12:38 AM GMT
Subject: Ask again: Question about DBD::mysql



hi,all;
I use DBD::mysql to connect mysql server on linux system.

But I can't use $sth-> {precision}, $sth->{scale}, $dbh->typeinfo.
And $dbh-> type_info_all return empty structure.
Does DBD::MySQL support it?

I get $sth-> {TYPE}, it is a number, how to convert it to human readable
string?

And is there any better way to get table structure?

Thanks.

Regards;
Michael



------------------------------------------------------------------------------
DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
To unsubscribe from this list, please visit:
http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web
page,
please send mail to dbi-users-request@[...].org with the subject line of:
'unsubscribe'.
------------------------------------------------------------------------------


______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup


------------------------------------------------------------------------------
DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web page, 
please send mail to dbi-users-request@[...].org with the subject line of:
'unsubscribe'.
------------------------------------------------------------------------------