有可能用perl创建一个带mysql的接口吗？ [英] possible to create an interface with mysql with perl?

问题描述

大家好，


我正在探索mysql数据库，需要在以后的阶段进行设计

但只是一个查询，

i know perl有可以链接到mysql数据库的模块

但是perl可以创建一个程序，这样访问数据库的用户只需要输入字段想要在程序提示时查询，例如：


a）用户名

b）日期和时间

c）活动


''我想我设计一个，以便访问数据库的用户尽可能避免使用mysql语句

谢谢

解决方案

这听起来像是在phpMyAdmin或MySQLman之后。哪个是第三方软件已经做了你想要的。


可以在perl中完成吗？是的，MySQLMan是用perl编写的。


--Kevin

哇......这很酷

有这么多支持软件的mysql


i发现像..

mySQL管理员附带mySQL，navicat for mysql，sqlyog


但仍然要求你支付使用但值得考虑


hm..alright

然后我知道那里'''这些模块比如DBI和sort

这些也有助于从你的数据库中取出数据吗？

如果你想要做一些简单的编程

DBI是非常有用的，我只是没有看到有必要重写一个运行良好的程序，并拥有比我自己提供的更大的支持社区。至少对于你想要的任务。我已经使用MySQLMan大约5年了，并且喜欢它。我也使用phpMyAdmin。


--Kevin

hi all,

i''m in the process of exploring mysql database and need to design it at a later stage
but just a query,
i know perl has modules that can link to mysql database
but is it possible for perl to create a program such that a user accessing the database need only to input fields he wants to query when prompted by the program, say for eg:

a) user name
b) date and time duration
c) activities

''cos i''m thinking of designing one so that a user accessing the database avoid as much of mysql statement as possible
thanks

解决方案

It sounds like you are after phpMyAdmin or MySQLman. Which are third party software that already does what you want.

Can it be done in perl? Yes, MySQLMan is written in perl.

--Kevin

wow..that''s cool
there''s like so many support software for mysql

i found like..
mySQL admin which comes with mySQL, navicat for mysql, sqlyog

but still requires you to pay to use but worth considering

hm..alright
then i know there''s modules like DBI and sort
these also helps to take out data from yr databases right?
if u were to want to do some simple programming yrself that is

The DBI is very useful, I just don''t see the need to rewrite a program that works well and has a bigger support community than I can offer myself. At least for the tasks that you are wanting. I have been using MySQLMan for about 5 years now and love it. I also use phpMyAdmin too.

--Kevin

这篇关于有可能用perl创建一个带mysql的接口吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！