All geek questions in one place

Automate sql connections using perl

I have a web application with an interface that queries the MySQL database and presents the requested data to the user. The database contains 25 tables; There are foreign keys related to tables. The problem here is that users are completely unfamiliar with SQL; I cannot expect them to join the tables.

I want to write a script that automatically creates connections. I want to know if there are any modules in Perl that make this easy?

My own experience with SQL is only a few months. Please let me know your opinion about this.

+3
source share
2 answers

, , . , / ( ), NULL ( ), , .

, , Sybase ( MySQL), , , , .

, :

  • -, ( , , / ).

  • "" "".

    - , , , ( , , , , ). . "" " " - , . "" ( ) " ", / patron_id .

  • . , - ( / ); , , . , FOREIGN, , . (, - "patron_id", "" )

  • . , . ( ? Y/n?). .

+2

- , Perl DBI.

0

Source: https://habr.com/ru/post/1782334/

More articles:


All Articles