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. | USING MYSQL WITH PERL 13 ActivePerl includes optional modules to work with Microsoft s 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 Microsoft s Web site 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 Microsoft s Windows Installer utility and as an .exe file that includes the Window Installer. You can download Apache for Windows from the Apache Software Foundation s Web site . Apache the most recent stable release is tested and reliable on Windows systems and a good alternative to Microsoft s 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. The next screen allows you to choose components and the install location. Make any changes desired and click Next to continue. The final options screen is displayed. Q Click Next and then click Install on the following screen to complete the installation. 247 MySQL INSTALL THE PERL DBI The DBI package for Perl supports a number of different database systems. Because it uses the same syntax for all database servers you can use it to write portable Perl applications that work with any supported database server. Along with the DBI you will need to install a separate database driver or DBD for each database server your applications will be working with. The DBI for Perl is available from the MySQL Web page in the Downloads section. For UNIX systems this is distributed as a
