Re: perl with mysql which takes a file as a input that contains the info to create the tables
- From: prady184u@xxxxxxxxx (Pradeep Kumar)
- Date: Wed, 31 Oct 2007 11:50:05 +0530
hi Rob,
What exactly i wanted to do is..
to take a input from a file of format :
INPUT.txt :
Details> name , id INTEGER, area VARCHAR(32)
prady,2039,india
sandy,2398,india
sam,1234,aussie
Rob,2345,Eng
extraDetails>name1 VARCHAR(12), name2 VARCHAR(12)
prady,sandy
sandy,Rob
Rob,sam
sam,prady
in the above text format u can find two tables one is Details> & the other
is extraDetails>
so i wanted to take the line Details> for creating table , & the values
below it for inserting into the table. similarly the second shud be find out
(extraDetails) & those values shud be inserted in to its table
& one more script the other way round like by getting the (retrieving) the
data from the mysql database using some queries & creating a file in the
above specified INPUT.txt format.
could u please help me in this regard
thanx
Regards
Prady
On 10/30/07, Rob Coops <rcoops@xxxxxxxxx> wrote:
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/
--
wid luv
prady
- References:
- Prev by Date: problem in returning the hash reference
- Next by Date: Re: problem in returning the hash reference
- Previous by thread: Re: 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
|
