mysql_config. No
problem, I can set it:
===
# perl Makefile.PL --mysql_config=/usr/local/mysql/5.6/bin/mysql_config
--cflags="-m32"
PLEASE NOTE:
For 'make test' to run properly, you must ensure that the
On Feb 19, 2014, at 4:20 AM, Dr.Ruud wrote:
> my $sth_4;
> ...
> (untested)
Thanks for the code but I still get the same error: DBD::mysql::st
execute failed: You have an error in your SQL syntax;
- Long pause for trial and error --
Well with the he
On 2014-02-18 02:27, SSC_perl wrote:
I'm helping someone retrieve some info from a MySQL db and I'm having
trouble sending multiple select statements with Perl. Here's a portion of the
code:
use SQL::SplitStatement;
my $query_4 = "CREATE TEMPORARY TABLE `tem
I'm helping someone retrieve some info from a MySQL db and I'm having
trouble sending multiple select statements with Perl. Here's a portion of the
code:
use SQL::SplitStatement;
my $query_4 = "CREATE TEMPORARY TABLE `temp_ip` AS
(SELECT `ip`
FROM `ip_address
Nevermind, I was thinking too hard... this was actually quite trivial.
Here's what I added to the code:
my $row;my $date = '';
# set the `logbook` variableswhile ($row = $sth->fetchrow_hashref())
{my $id = $row->{id};my $date_added =
DateTime::Format::MySQL->parse_tim
<http://stackoverflow.com/questions/18809731/mysql-perl-and-latex-trying-to-loop-through-results-by-day-as-a-latex-sectio#>
I have written a Perl script (shown below) to loop through my MySQL
database and then output a .tex file, as a sort of programmed custom
report. As it stands, it
On 05/09/2013 02:28, J M wrote:
However, I'm running into a problem: the FIRST instance of
DateTime::Format::MySQL works perfectly... but when I get to the second
one, it throws me this error:
Use of uninitialized value $input in concatenation (.) or string at
/usr/local/share/perl/5
Hi!
I'm writing a simple script to output data from a MySQL database...
Eventually I'd like to pipe it all into a .tex file and make a custom pdf
out of it.
However, I'm running into a problem: the FIRST instance of
DateTime::Format::MySQL works perfectly... but when I get to the
In my script, I previous connected and disconnected to the database within
every subroutine. Now I have made changes and it now connect/disconnect to
mysql only once within main:: (at the start and end of script
respectively). Although my script works fine, I am wondering whether this
is the best
I've tried posting this to the perl-mysql mailing list but that list
doesn't seem to have any traffic, so I'm hoping maybe someone on this list
has some experience with Apache::Session::MySQL.
Does anyone know if a call to untie on a tied hash
to Apache::Session::MySQL will clo
Hi.
On Mon, Jul 2, 2012 at 10:31 AM, David Precious wrote:
> On Mon, 2 Jul 2012 23:22:47 +0800
> lina wrote:
>
> > Hi,
> >
> > Is this book old?
> >
> > http://www.kitebird.com/mysql-perl/
> >
> > MySQL and Perl for the Web
>
> "New
On Mon, 2 Jul 2012 23:22:47 +0800
lina wrote:
> Hi,
>
> Is this book old?
>
> http://www.kitebird.com/mysql-perl/
>
> MySQL and Perl for the Web
"New Riders, August, 2001"
Yes. Very much so.
A lot of it will be very outdated information.
DBI's own
Hi,
Is this book old?
http://www.kitebird.com/mysql-perl/
MySQL and Perl for the Web
Thanks with best regards,
--
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional commands, e-mail: beginners-h...@perl.org
http://learn.perl.org/
On 21/10/11 at 10:12, phildob...@gmail.com (Phil Dobbin) wrote:
On 20/10/11 at 17:35, phildob...@gmail.com (Phil Dobbin) wrote:
I’m trying to install DBD-mysql-4.020 on OS X 10.6.8 with a
fresh install of perl in /usr/local/ (perl 5.14.2) which is in
my $PATH.
[snip]
If anybody’s
On 20/10/11 at 17:35, phildob...@gmail.com (Phil Dobbin) wrote:
I’m trying to install DBD-mysql-4.020 on OS X 10.6.8 with a
fresh install of perl in /usr/local/ (perl 5.14.2) which is in
my $PATH.
[snip]
[snip
Hi.
I’m trying to install DBD-mysql-4.020 on OS X 10.6.8 with a
fresh install of perl in /usr/local/ (perl 5.14.2) which is in
my $PATH.
I have a working MySql in /usr/local/ (MySQL 5.1.59) & the
latest Bundle-DBI.
I’ve tried from CPAN & compiling from source, scoured the
Int
nd up rather than learning any
particular framework. I'm considering buying:
- Galbraith, P., 2009, "Developing Web Applications with Apache, MySQL,
memcached, and Perl",
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470414642.html .
Has anyone read this book?
Any com
From: "Agnello George"
> >
>> This interpolation of string variables into an SQL statement is an SQL
>> injection attack waiting to happen:
>>
>> * http://en.wikipedia.org/wiki/SQL_injection
>>
>> * http://community.livejournal.com/shlomif_tech/35301.html
>>
>> * http://bobby-tables.com/
>>
>> Pl
>
> This interpolation of string variables into an SQL statement is an SQL
> injection attack waiting to happen:
>
> * http://en.wikipedia.org/wiki/SQL_injection
>
> * http://community.livejournal.com/shlomif_tech/35301.html
>
> * http://bobby-tables.com/
>
> Please avoid it by using placeholders.
From: "Agnello George"
> great !! i used tinymce in my insert form that solved all my html alignment
> problem :)
It would be much great if you wouldn't quote more than 140 lines of previous
messages just to answer a single line... :-)
Octavian
--
To unsubscribe, e-mail: beginners-unsubscr..
gt;> > Hi
>>> >
>>> > I am using TT to display my data from my db ,
>>> >
>>> >
>>> >
t;> >
>> > i insert the following data from a Front end using ()
>> into
>> > my database the data is like this in mysql :
>> >
>> >
>> ---
>> > --
On Friday 27 May 2011 15:51:21 Agnello George wrote:
> On Fri, May 27, 2011 at 6:05 PM, Shlomi Fish wrote:
> > On Friday 27 May 2011 13:48:21 Agnello George wrote:
> > > Hi
> > >
> > >
> > > is there a way i can display on my browser with a new-line or
> >
> > First of all, make sure you avoi
On Fri, May 27, 2011 at 6:05 PM, Shlomi Fish wrote:
> On Friday 27 May 2011 13:48:21 Agnello George wrote:
> > Hi
> >
> > I am using TT to display my data from my db ,
> >
> >
> > i insert the following data from a Front end using ()
> into
> &
On Friday 27 May 2011 13:48:21 Agnello George wrote:
> Hi
>
> I am using TT to display my data from my db ,
>
>
> i insert the following data from a Front end using () into
> my database the data i
Hi
I am using TT to display my data from my db ,
i insert the following data from a Front end using () into
my database the data is like this in mysql
>From: shawn wilson [mailto:ag4ve...@gmail.com]
>Sent: Saturday, February 12, 2011 5:56 PM
>To: beginners@perl.org
>Subject: DBD::mysql::st execute failed
>
>i'm getting this error:
>DBD::mysql::st execute failed: Column count doesn't match value count at
row
>1
i'm getting this error:
DBD::mysql::st execute failed: Column count doesn't match value count at row
1 at ./test-get.pl line 91, line 1.
DBD::mysql::st execute failed: Column count doesn't match value count at row
1 at ./test-get.pl line 91, line 1.
and i've been counting p
It probably had warnings and failed due to no password being passed on
the test. I believe that Net::MySQL and DBI installed properly, now
on to DBD, which seems to be failing due to the fact that it cannot
locate some MySQL header files.
--
To unsubscribe, e-mail: beginners-unsubscr
all DBD, DBI and Net::MySQL and all failed. It
> is possible that the reason why the installs are failing is common to
> all three, but I do not know that as a fact, so I am asking you to
> look over and respond as to what I may be doing wrong in the
> installation of Net::MySQL.
>
&g
My installation of RedHat Linux server 5.3 came with PERL 5.8. I
updated my version of PERL to 5.12, and my copy of PERL resides at /
root/localperl/bin/perl
I've attempted to install DBD, DBI and Net::MySQL and all failed. It
is possible that the reason why the installs are failing is c
rom: rvtol+use...@isolution.nl
> Subject: Re: MySQL database entry delta report
>
> On 2010-10-18 05:42, Jason Feng wrote:
>
> > I am using
> > Perl and MySQL to maintain a database of mobile network configuration about
> > 30
> > tables and millions of ro
This is the wrong list for MySQL questiosn, but I believe you are probably
looking to replace the matching record, use MySQL "INSERT REPLACE INTO
tablename".
Mimi
=> -Original Message-
=> From: S Pratap Singh [mailto:kdari...@gmail.com]
=> Sent: 20 Octob
how to achieve
> this "IF EXISTS then UPDATE else INSERT" using a one liner MYSQL
> statement . If someone can give me an example to write such query and
> execute it from perl then it would be really appreciated.
This isn't a Perl question, you're asking in the wrong pl
:
>
>
> SPS> Insert query works fine but I am not able to figure out how to
> SPS> achieve this "IF EXISTS then UPDATE else INSERT" using a one
> SPS> liner MYSQL statement . If someone can give me an example to
> SPS> write such query and execute it from
>>>>> "SPS" == S Pratap Singh writes:
SPS> Insert query works fine but I am not able to figure out how to
SPS> achieve this "IF EXISTS then UPDATE else INSERT" using a one
SPS> liner MYSQL statement . If someone can give me an example to
SP
one liner MYSQL statement . If
someone can give me an example to write such query and execute it from perl
then it would be really appreciated.
Thank you.
Pratap
On 2010-10-18 05:42, Jason Feng wrote:
I am using
Perl and MySQL to maintain a database of mobile network configuration about 30
tables and millions of rows. Every day, I’ll be importing new configuration
data to the database.
I’d like to create a delta report on which row and which
column are
于 2010-10-18 11:42, Jason Feng 写道:
Hello,
I am using
Perl and MySQL to maintain a database of mobile network configuration about 30
tables and millions of rows. Every day, I’ll be importing new configuration
data to the database.
I’d like to create a delta report on which row and which
Hello,
I am using
Perl and MySQL to maintain a database of mobile network configuration about 30
tables and millions of rows. Every day, I’ll be importing new configuration
data to the database.
I’d like to create a delta report on which row and which
column are modified, which row is
(binary file) into the db table.
The example on MySQL forum is discussing using the use of MySQL Query
Browser to manually insert each picture into a database and that is not
possible when the large number of pictures is involved or when users are to
upload pictures using a web form.
http
Mimi Cafe wrote:
Anyone worked on a project where they have stored pictures in MySQL db from
Perl program? I need to store pictures in MYSQL and my initial thought was
a normal insert statement. Now I did a bit of search and people are making
it completed out there. I have not tried it, but I
On Thursday 22 Jul 2010 06:48:08 Mimi Cafe wrote:
> Anyone worked on a project where they have stored pictures in MySQL db from
> Perl program? I need to store pictures in MYSQL and my initial thought was
> a normal insert statement. Now I did a bit of search and people are making
>
2010/7/22 Mimi Cafe :
> Anyone worked on a project where they have stored pictures in MySQL db from
> Perl program? I need to store pictures in MYSQL and my initial thought was
> a normal insert statement.
Nothing much about Perl, but the stuff related to Mysql itself. A referen
Anyone worked on a project where they have stored pictures in MySQL db from
Perl program? I need to store pictures in MYSQL and my initial thought was
a normal insert statement. Now I did a bit of search and people are making
it completed out there. I have not tried it, but I was thinking of
> "MC" == Mimi Cafe writes:
MC> yes, probably the space was the cause of the issue. I did not
MC> notice it untill I went back to change the quotes.
hopefully you have learned a lesson about quoting strings. but you
haven't about quoting emails. my entire email was quoted below your
repl
yes, probably the space was the cause of the issue. I did not notice it
untill I went back to change the quotes.
Mimi
On 19 April 2010 19:16, Uri Guttman wrote:
> > "MC" == Mimi Cafe writes:
>
> MC> Hmm, the single quotes did help. I am used to double quotes as
> MC> they make me feel I
> "MC" == Mimi Cafe writes:
MC> Hmm, the single quotes did help. I am used to double quotes as
MC> they make me feel I am properly quoting, but now I have learnt the
MC> hard way.
there is no reason single vs double quotes would make any difference as
there was no interpolation going o
Subject: AW: Can't locate object method "TIEHASH" via package "
Apache::Session::MySQL
Owen wrote:
> On Mon, 19 Apr 2010 00:14:44 +0100
> Mimi Cafe wrote:
>
> > I get following error when trying to open a session using
> > Apache::Session::M
Owen wrote:
> On Mon, 19 Apr 2010 00:14:44 +0100
> Mimi Cafe wrote:
>
> > I get following error when trying to open a session using
> > Apache::Session::MySQL.
> >
> >
> >
> > Here is what I have
> >
> >
> >
> > 38
On Mon, 19 Apr 2010 00:14:44 +0100
Mimi Cafe wrote:
> I get following error when trying to open a session using
> Apache::Session::MySQL.
>
>
>
> Here is what I have
>
>
>
> 38 tie %session, " Apache::Session::MySQL", undef,{
>
I get following error when trying to open a session using
Apache::Session::MySQL.
Here is what I have
38 tie %session, " Apache::Session::MySQL", undef,{
39 Handle => $dbh,
40 LockHandle => $dbh
41 };
Could not create ne
Ryan Chan wrote:
Sometimes, my sql is running for a quite long time, e.g. 1 hour
The perl script will warn "DBD::mysql::st execute failed: MySQL server
has gone away at ..." and my script failed.
I have already set the auto reconnect, e.g.
$dbh->{mysql_auto_reconnect} = 1;
Hello,
Sometimes, my sql is running for a quite long time, e.g. 1 hour
The perl script will warn "DBD::mysql::st execute failed: MySQL server
has gone away at ..." and my script failed.
I have already set the auto reconnect, e.g.
$dbh->{mysql_auto_reconnect} = 1;
But problem sti
On Fri, Oct 9, 2009 at 12:24 PM, Noah wrote:
> Hi there,
>
> I am just starting with Mysql and perl and would like to know how to store
> things in a database. Is there any suggested existing code out there that
> does this already that I can view to get an understand
Hi there,
I am just starting with Mysql and perl and would like to know how to
store things in a database. Is there any suggested existing code out
there that does this already that I can view to get an understanding of
the data structures? Is there a good how to help page out there
ow can I install Perl DBD, DBI::mysql
> Modules
>
> I have an Intel Mac OS X (10.5.6) Leopard with Perl v5.8.8 built for
> darwin-thread-multi-2level
>
--
Francisco Valladolid H.
-- http://bsdguy.net - Jesus Christ follower.
--
To unsubscribe, e-mail: beginners-unsubscr...@
Hi there, I would like to know how can I install Perl DBD, DBI::mysql
Modules
I have an Intel Mac OS X (10.5.6) Leopard with Perl v5.8.8 built for
darwin-thread-multi-2level
e ADD 546 VARCHAR( 250 ) NULL");
> ---->is a numeric column label and throwsback the following
> error:
>
> DBD::mysql::db do failed: You have an error in your SQL syntax; check
> the manual that corresponds to your MySQL server version for the right
> syntax to use nea
>is a non-numeric column label and works fine.
However, changing "testname" to a number results in an error..
$dbh->do("ALTER TABLE goodtable ADD 546 VARCHAR( 250 ) NULL");
>is a numeric column label and throwsback the following
error:
DBD::mysql::d
On Nov 13, 4:56 pm, [EMAIL PROTECTED] (Deviloper) wrote:
> I have a SQL-Statement with a Regular Expression and I want to use a scalar
> in that expression: (Looking for something like "$tool =~ m/\Q$x\E/" )
>
> #Find tools with xx in the name:
> $dbh->prepare ("SELECT name FROM toolbox WHERE
I have a SQL-Statement with a Regular Expression and I want to use a scalar in
that expression: (Looking for something like "$tool =~ m/\Q$x\E/" )
#Find tools with xx in the name:
$dbh->prepare ("SELECT name FROM toolbox WHERE name REGEX '$x'");
#or
$dbh->prepare ("SELECT name FROM toolbox
From: Qinying Xu
>
> I am coding an web appliction, which should connect to
> Mysql DB. I tried the connection source cold on Linux,
> it works well. But when I run it through the web, the
> scripts just stopped. I found it died after runing the
> line:
> my $conn =
I am coding an web appliction, which should connect to Mysql DB. I tried the
connection source cold on Linux, it works well. But when I run it through the
web, the scripts just stopped. I found it died after runing the line:
my $conn =
Mysql->connect($self->{db_host},$self->{db_na
if (! defined($myvar)) {
The NULL in the database is mapped to an undef.
Jenda
= [EMAIL PROTECTED] === http://Jenda.Krynicky.cz =
When it comes to wine, women and song, wizards are allowed
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery
Thank yo
Huub <[EMAIL PROTECTED]> asked:
> I'm adapting a Perl script using MySQL connectivity, and have
> to compare a variable, e.g. $myvar, with the value NULL from
> the database. In MySQL, I have to use the query 'where myvar
> is null', which works great.
> B
From: Huub <[EMAIL PROTECTED]>
> I'm adapting a Perl script using MySQL connectivity, and have to compare
> a variable, e.g. $myvar, with the value NULL from the database. In
> MySQL, I have to use the query 'where myvar is null', which works great.
> But
Hi,
I'm adapting a Perl script using MySQL connectivity, and have to compare
a variable, e.g. $myvar, with the value NULL from the database. In
MySQL, I have to use the query 'where myvar is null', which works great.
But when I try this in Perl, like 'if ($myvar == null)
luke devon schreef:
> I just tried to store some mysql-queried data in to a file. but it
> wont work. Actually i wanted to do not just writing , it should be
> APPEND at each time when that perl scripts runs.
>
> Can some body help me , if you all can provide me a sample or a
pen file: $!";
>
> #read each line of query results
> foreach my $line(@$data){
> print FILE "$line->{field1}, $line->{field2}\n";
> }
>
> #close file
> close (FILE)
>
> #disconnect from database
> $dbh->disconnect;
>
>
> On Thu, Jul 3,
ield1}, $line->{field2}\n";
}
#close file
close (FILE)
#disconnect from database
$dbh->disconnect;
On Thu, Jul 3, 2008 at 2:46 AM, luke devon <[EMAIL PROTECTED]> wrote:
> Hi ,
>
> I just tried to store some mysql-queried data in to a file. but it wont
> work. Actua
Hi ,
I just tried to store some mysql-queried data in to a file. but it wont work.
Actually i wanted to do not just writing , it should be APPEND at each time
when that perl scripts runs.
Can some body help me , if you all can provide me a sample or a example would
be a great help
Many
sanket vaidya wrote:
I cannot instead module using ppm or MCPAN (office proxy wont allow me to do
this) & I have never installed a perl module manually. I am installing
DBD::mysql module. When I get into the module directory & type "perl
makefile.pl" I get error as below:
F
Hi,
I cannot instead module using ppm or MCPAN (office proxy wont allow me to do
this) & I have never installed a perl module manually. I am installing
DBD::mysql module. When I get into the module directory & type "perl
makefile.pl" I get error as below:
Failed to dete
> In your new code you retrieve each record as a hash, keyed by field
> name. Then, instead of your subroutine returning the result as it did
> before, you copy the hash elements directly into your object.
Correct. Essentially what I want is to absolutely minimize any work I
have to do outside of
Steve Bertrand wrote:
>
Tom Phoenix wrote:
>>
Steve Bertrand wrote:
The current setup feels very 'kludgy' to me. The code snip below comes
out of the module. I hope there is enough context to see why I think it
can be improved.
Actually, the snippet you submitted seems pretty straightforward
Tom Phoenix wrote:
> On 11/27/07, Steve Bertrand <[EMAIL PROTECTED]> wrote:
>
>> The current setup feels very 'kludgy' to me. The code snip below comes
>> out of the module. I hope there is enough context to see why I think it
>> can be improved.
>
> Actually, the snippet you submitted seems pret
On 11/27/07, Steve Bertrand <[EMAIL PROTECTED]> wrote:
> The current setup feels very 'kludgy' to me. The code snip below comes
> out of the module. I hope there is enough context to see why I think it
> can be improved.
Actually, the snippet you submitted seems pretty straightforward. It
could b
Hi all,
I am trying to modularize some standard MySQL queries that I frequently
do against our RADIUS DB.
The current setup feels very 'kludgy' to me. The code snip below comes
out of the module. I hope there is enough context to see why I think it
can be improved.
Essentially,
Lists [mailto:[EMAIL PROTECTED]
Sent: Friday, November 16, 2007 9:23 AM
To: beginners@perl.org
Subject: RE: :mysql::st execute failed: Column count doesn't match value
count at row 1 a
my $sql="insert into $table values
('2345','4355','834','894,&#x
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 examp
er tables I am able to
> isnert data
>
>
>
> --
>
> DBD::mysql::st execute failed: Column count doesn't match value count
my $sql="insert into $table values
('2345','4355','834','894,'766');
You have an unmatched double quote here.
Jo
<>
On Nov 16, 2007 1:52 AM, Pradeep Kumar <[EMAIL PROTECTED]> wrote:
snip
> NOW I WANTED TO KNOW THE PROCEDURE FOR TAKING THE CODE AS INPUT FROM A
> TEXT FILE & CREATE THE SPECIFIED TABLE
snip
Don't yell.
Warning, this is untested code and may blow up in your face. Second
warning, this code is very
--
DBD::mysql::st execute failed: Column count doesn't match value count at row
1 a
t db_access.pm line 63.
Below is my script
my $XML_FILE="E:/Project/scripts/Master.xml";
my $ref = eval {
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
Gunnar Hjalmarsson schreef:
> Tom Phoenix:
>> Generally, top-posting is preferred in public forums.
>
> s/top-posting/bottom-posting/
http://en.wikipedia.org/wiki/Top-posting#Inline_replying
--
Affijn, Ruud
"Gewoon is een tijger."
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addit
Tom Phoenix wrote:
Generally, top-posting is preferred in public forums.
s/top-posting/bottom-posting/
--
Gunnar Hjalmarsson
Email: http://www.gunnar.cc/cgi-bin/contact.pl
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org
On Tuesday 13 November 2007 14:53, Tom Phoenix wrote:
>
> Generally, top-posting is preferred in public forums.
It is? That's news to me! :-(
John
--
use Perl;
program
fulfillment
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.p
On 11/12/07, Siva Prasad <[EMAIL PROTECTED]> wrote:
> I am still stuck up with the below problem.
Generally, top-posting is preferred in public forums. Begin by quoting
the minimum, relevant, context; follow with whatever is new.
> Please help me in intalling DBD::mysql on WinXP
H
hi,
Tanks for your help, finally i found the "source" command. It work like
this:
mysql> source /Lhome/geruppa/mhc/Pack_Ref_web/prova.sql
2007/11/9, Michael Gargiullo <[EMAIL PROTECTED]>:
>
> On Fri, 2007-11-09 at 13:22 +0100, Pau Marc Munoz Torres wrote:
>
&
I am still stuck up with the below problem.
Please help me in intalling DBD::mysql on WinXP
Thanks
PP
-Original Message-
From: Siva Prasad [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 01, 2007 11:09 AM
To: 'Tom Phoenix'
Cc: 'beginners@perl.org'
Subje
On 10/31/07, Siva Prasad <[EMAIL PROTECTED]> wrote:
> I use correct capital words and also used perl Makefile.pl --help could not
> figure out where I am wrong?
Are you still getting the message "Can't locate DBD/mysql.pm in @INC"?
If so, the module isn't properly installed yet.
Cheers!
--Tom P
: beginners@perl.org
Subject: Re: errror while installing DBD::MYSQL.
On 10/31/07, Siva Prasad <[EMAIL PROTECTED]> wrote:
> so I downloaded perl DBD::MYSQL and tried installing the module with no
> luck.
Perl is case-sensitive with regard to module names. Be sure to use the
correct capitaliza
On 10/31/07, Siva Prasad <[EMAIL PROTECTED]> wrote:
> so I downloaded perl DBD::MYSQL and tried installing the module with no
> luck.
Perl is case-sensitive with regard to module names. Be sure to use the
correct capitalization in your code.
> Failed to determine directory of
l);
print "$data\n";
--SCRIPT.
I got the below error.
----
-----
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
contains:
C:/Perl/site/lib C:/Perl/lib .) at (eval 4) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the cap
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,
file (using perl script)
> > into MySQL database is through (?) place holders.
> >
> That is not correct.
Right.
> > for example ,
> >
> > $sth=$dbh->prepare
> > ("INSERT INTO checkin (firstname, lastname,
> > destin
prady 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
That is not correct.
MySQL database is through (?) place
[EMAIL PROTECTED]> 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 th
1 - 100 of 666 matches
Mail list logo
