From: Jochen Wiedmann Date: November 13 1999 4:20pm Subject: Re: Determination of table and database from field in select... List-Archive: http://lists.mysql.com/perl/415 Message-Id: <382D8FC1.CA65280C@ispsoft.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Michael Widenius wrote: > The MySQL C API can be used to get the table name for each column, but > I don't know if you can get this through DBI/DBD (I scanned through > 'perldoc DBI', but couldn't find anything specific); Maybe someone on > the msql-mysql-modules lists knows something about this... Use $sth->{'mysql_table'}. It used to be $sth->{table}, but the latter is deprecated. Bye, Jochen -- Jochen Wiedmann joe@stripped Life has brown and green eyes. :-) +49 711 7168586