From: Brandon Shuey Date: March 19 1999 4:53am Subject: RE: Creation of Databases in perl? List-Archive: http://lists.mysql.com/mysql/558 Message-Id: <001501be71c4$6ef19f50$48c92499@shueybox> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Checkout http://mysql.turbolift.com/mysql/contact.txt > -----Original Message----- > From: mike@stripped [mailto:mike@stripped]On Behalf > Of Mike Machado > Sent: Thursday, March 18, 1999 10:46 PM > To: Justin Plock > Cc: mysql@stripped > Subject: Re: Creation of Databases in perl? > > > 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 > > > > > --------------------------------------------------------------------- > To request this thread, e-mail mysql-thread557@stripped > To unsubscribe, e-mail the address shown in the > List-Unsubscribe header of this message. > For additional commands, e-mail: mysql-help@stripped > >