Perl DBI / SQL问题

Vance M. Allen写道：

Vance M. Allen wrote:

如果交叉发布不合适，我很抱歉，但我需要帮助有了这个
并且我不确定在MySQL或Perl下发帖是否更合适...我想确保我可以从最佳来源获得帮助。

我需要知道如何通过Perl DBI检索字段中可能的ENUM
元素列表，以便在CGI脚本下进行处理。如果我只需要
这是某种形式的SELECT语句，请提供一个代码片段，这样我就可以做到。

我想制作我的代码所以我如果/当我向ENUM字段添加新元素时，则不必编辑硬编码的Perl CGI
脚本。非常感谢您提供的任何帮助。

非常感谢！

Vance

Sorry if the cross-posting wasn''t appropriate, but I need help with this
and am not sure if it''s more appropriate to post under MySQL or Perl...I
want to be sure that I can get help from the best source.

My question is probably a simple answer, but I am not sure what I have to
do and the books I have here are either not answering the question, or I''m
not finding the answer.

I need to know how to retrieve through Perl DBI a listing of possible ENUM
elements from a field for processing under a CGI script. If all I need
for this is some form of SELECT statement, please provide a code snippet
of this so I can do it.

I want to make my code so I''m not having to edit hard-coded Perl CGI
scripts
if/when I add new elements to the ENUM field. Any help you can provide
would be greatly appreciated.

Thanks!

Vance

我不是知道是否有内置的可能会这样做，但它让我想到了b $ b。这是肮脏的事情。


我的

I don''t know if there''s a built-in may of doing this, but it got me
thinking. Here''s a dirty was of doing it.

my

sth =

dbh-&gt ; prepare（DESCRIBE tablename fieldname）;

dbh->prepare("DESCRIBE tablename fieldname");