This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
Subject: ANNOUNCE: Tutorial # 24 (26-Aug-2000). perl-tut-24-books.zip From: "Ron Savage" <ron@savage.net.au> Date: Sat, 26 Aug 2000 17:43:14 +1000 This shows you how to load a text file (here book data) into MySQL. See my Links page for the URL of the MySQL home page. Note: This tutorial assumes you've run secure-MySQL.pl from tutorial # 23, or something similar, to create the username/password = book/lover. import_books.pl: - Drop existing tables - Create new tables for Publishers and Books - Read a text file - Create records in the Publishers database, if not already there - Create a link from the Book record to the corresponding Publisher record - Create records in the Books database export_books.pl: - Export all records from the 2 databases into an HTML table. See my Books page for the output Other files: book_list.txt: The input data (which doubles as a backup file) book_lib.pl: The Perl model of the Books database publisher_lib.pl: The Perl model of the Publisher database db_lib_non_cgi.pl: The non-cgi version of my generic Perl-DBI interface. See http://savage.net.au/Perl-tutorials.html === Subject: ANNOUNCE: Tutorial # 25 (26-Aug-2000). perl-tut-24-wine.zip From: "Ron Savage" <ron@savage.net.au> Date: Sat, 26 Aug 2000 17:43:59 +1000 This shows you how to load a text file (here wine data) into MySQL. See my Links page for the URL of the MySQL home page. Note: This tutorial assumes you've run secure-MySQL.pl from tutorial # 23, or something similar, to create the username/password = wine/lover. import_wine.pl: - See import_books.pl below for the general idea export_wine.pl: - See export_books.pl below for the general idea Other files: wine_list.txt: The input data (which doubles as a backup file) wine_lib.pl: The Perl model of the Wine database winemaker_lib.pl: The Perl model of the Winemaker database db_lib_non_cgi.pl: The non-cgi version of my generic Perl-DBI interface. See http://savage.net.au/Perl-tutorials.html ===