From: Mike Machado
Date: March 19 1999 4:46am
Subject: Re: Creation of Databases in perl?
List-Archive: http://lists.mysql.com/mysql/557
Message-Id: <36F1D69B.226D56F3@innercite.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

You can go check myadmin.cheapnet.net and get the lastest MyAdmin and see
exactly how perl code can manage a mysql database.

Justin Plock wrote:

> I was wondering if anybody knew any way to create databases and tables from
> within a web-based perl script.  Someone gave me some sample code that
> basically is just piping the SQL commands to mysql:
>
> open (MYH, "|mysql --user=username --password=password") || die "Cannot open
> pipe to mysql\n";
> print MYH <<"EOF";
> drop table domains;
> drop table hosts;
> create table domains (ip char(15) not null primary key);
> create table hosts (ip char(15) not null primary key);
> EOF
>
> But this code don't seem to work.  Any suggestions would be appreciated.
> Thanks.
>
>                             -Justin Plock
>
> ---------------------------------------------------------------------
> To request this thread, e-mail mysql-thread556@stripped
> To unsubscribe, e-mail the address shown in the
> List-Unsubscribe header of this message.
> For additional commands, e-mail: mysql-help@stripped

--
Mike Machado
mike@stripped
InnerCite
Network Specialist