Re: perl with mysql which takes a file as a input that contains the info to create the tables
- From: rcoops@xxxxxxxxx (Rob Coops)
- Date: Tue, 30 Oct 2007 13:13:45 +0100
Hi Prady,
In your example script you are feeding the execute command a set of strings,
so you know that it will except a string.
Since the creation of a table is not something that you need to prepare, all
you will need to do is shove the create table command in a single string
(optionally with line feeds) and hand that to the $dbh->execute() command.
Whatever command your string contains is then executed on your database so
assuming your create table command was syntactically correct SQL the table
will be created in your database.
Regards,
Rob
*ps, you do not need to prepare your command on the database, but since you
are executing the same SQL command several times with just different
variables preparing the command on the database and using placeholders will
make the whole thing go a bit faster (assuming your database can work with
place holders.*
On 10/30/07, prady <prady184u@xxxxxxxxx> wrote:
hi all
i am creating a perl script which takes the input from the file to
create tables, inserting values into the database. As you all know the
only procedure for taking input from a file (using perl script) into
MySQL database is through (?) place holders.
for example ,
$sth=$dbh->prepare
("INSERT INTO checkin (firstname, lastname, destination)
VALUES
(? , ? , ? )");
$rows=0;
open FILE, "passlist.txt" or die $!;
while (<FILE>) {
chomp;
($firstname, $lastname, $destination) = split(/:/);
$sth->execute($firstname, $lastname, $destination)
|| die "Couldn't insert record : $DBI::errstr";
$rows+=$sth->rows();
}
Where the passlist.txt hav the data in the format
Tim:Briggs:Glasgow
Simon:Cozens:Japan
Richard:Collins:Japan
Daniel:Maharry:Glasgow
Emma:Batch:Thailand
Now it is perfect that v can take input from a file...
P.S. : But i wanted to take INPUT that contains the info to create the
tables
Where
CREATE TABLE checkin (
id INTEGER AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(32) NOT NULL,
lastname VARCHAR(32) NOT NULL,
checkedin INTEGER,
numberofbags INTEGER,
destination VARCHAR(32) NOT NULL)
NOW I WANTED TO KNOW THE PROCEDURE FOR TAKING THE CODE AS INPUT FROM A
TEXT FILE & CREATE THE SPECIFIED TABLE
awaiting ur reply
Regards
prady
--
To unsubscribe, e-mail: beginners-unsubscribe@xxxxxxxx
For additional commands, e-mail: beginners-help@xxxxxxxx
http://learn.perl.org/
- Follow-Ups:
- References:
- Prev by Date: Re: Include variables from external perl script
- Next by Date: Perl 5.8.6 bug in open()?
- Previous by thread: perl with mysql which takes a file as a input that contains the info to create the tables
- Next by thread: Re: perl with mysql which takes a file as a input that contains the info to create the tables
- Index(es):
Relevant Pages
|
