Mysql your visual blueprint for creating open source databases- P14

Mysql your visual blueprint for creating open source databases- P14:The show tables command displays a list of tables available in the currently selected database. You can use this command when you are unsure of the exact name of a table within the database.
Nội dung trích xuất từ tài liệu:
Mysql your visual blueprint for creating open source databases- P14 USING MYSQL WITH PERL 13 ActivePerl includes optional modules to work with Microsofts IIS Web server, included with Windows 2000 Server and Windows XP Server. You can choose to install these modules within the Setup Wizard when you are installing ActivePerl. For more information about IIS, see Microsofts Web site: www.microsoft.com/iis/. The Apache Web server is also available for Windows systems. If you do not have a Web server already, Apache is a good choice and is available at no charge. The 32-bit Windows version of Apache is provided as an .msi file for Microsofts Windows Installer utility and as an .exe file that includes the Window Installer. You can download Apache for Windows from the Apache Software Foundations Web site: www.apache.org/. Apache 2.0, the most recent stable release, is tested and reliable on Windows systems, and a good alternative to Microsofts IIS for many users. As with the UNIX version of Apache, you can install the mod_perl module to directly support Perl scripts from within the Web server. To use MySQL with ActivePerl, you will need to install the DBD and DBI modules for MySQL support. The process of installing these modules is described later in this chapter. ActivePerls The next screen allows you ‹ Make any changes s The final options screen is › Click Next, and then clickto choose components and desired and click Next to displayed. Install on the following screenthe install location. continue. to complete the installation. 247 MySQLINSTALL THE PERL DBI the files work correctly, and make install installs the DBIT he DBI package for Perl supports a number of different database systems. Because it uses the same in your Perl libraries. If the final command does not display syntax for all database servers, you can use it to write any error messages, the DBI should work on your server.portable Perl applications that work with any supported If you run into trouble with installation, there is somedatabase server. Along with the DBI, you will need to install documentation on the Perl DBI within the MySQLa separate database driver, or DBD, for each database server documentation, available from the MySQL Web site. Afteryour applications will be working with. the installation, you will need to install the DBD for MySQL.The DBI for Perl is available from the MySQL Web page, Under Windows systems, you can use the Perl Packagewww.mysql.com/, in the Downloads section. For UNIX Manager (PPM) included with ActiveStates Perl distributionsystems, this is distributed as a .tar.gz archive. You can to automatically install the DBI. To use this, start theexpand this archive and use the following commands to c:\perl\bin\ppm.pl program from a command promptcompile and install the DBI: window, and then type the following command:perl Makefile.PL install DBImakemake test MySQL also provides a downloadable Perl distribution formake install Windows that includes the DBI and DBD modules required for your scripts to connect to a MySQL server. See theThe first command sets up the compilation options for your Downloads page at the MySQL Web site for a link to thissystem. The make command compiles the programs for the distribution.DBI. The make test command runs some tests to make sure INSTALL THE PERL DBI⁄ Type cd followed by the s The files are expanded into ˇ Type make and press Enter. s The compiled files are nowdirectory name where the a new directory. tested..tar.gz file was downloaded s This compiles the files. ‹ Type cd followed by the ...