[prev in list] [next in list] [prev in thread] [next in thread]
List: mysql-win32
Subject: msql-mysql-modules Digest 29 Oct 2001 18:35:03 -0000 Issue 234
From: msql-mysql-modules-digest-help () lists ! mysql ! com
Date: 2001-10-29 18:35:03
[Download RAW message or body]
msql-mysql-modules Digest 29 Oct 2001 18:35:03 -0000 Issue 234
Topics (messages 1473 through 1479):
dirver for perl on linux
1473 by: Thuan Minh Tran
1476 by: Jon Molin
Creating user accounts and assinging previlages
1474 by: Rajeev Rumale
`Why WAIT??? Refiance NOW!!!
1475 by: nelsonhot.hotmail.com
INSERT, UPDATE and Groundhogs
1477 by: Jonathan M. Morgan
1478 by: Andreas Gietl
Apache/mod_perl/DBI/MySQL 4.0 alpha
1479 by: Michael Widenius
Administrivia:
To subscribe to the digest, e-mail:
msql-mysql-modules-digest-subscribe@lists.mysql.com
To unsubscribe from the digest, e-mail:
msql-mysql-modules-digest-unsubscribe@lists.mysql.com
To post to the list, e-mail:
msql-mysql-modules@lists.mysql.com
----------------------------------------------------------------------
["msql-mysql-modules_1473.ezm" (message/rfc822)]
From: "Thuan Minh Tran" <tmthuan@tma.com.vn>
To: <msql-mysql-modules@lists.mysql.com>
Subject: dirver for perl on linux
Date: Thu, 25 Oct 2001 11:59:24 +0700
Message-ID: <001501c15d11$d1abd0d0$8461a8c0@RND.TMA.COM>
MIME-Version: 1.0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi all,
I'm looking for a mysql driver for PERL on Linux, please show me where to
get it.
thanks a lot in advance,
["msql-mysql-modules_1476.ezm" (message/rfc822)]
Message-ID: <3BD80798.D3ED415F@resfeber.se>
Date: Thu, 25 Oct 2001 14:37:45 +0200
From: Jon Molin <Jon.Molin@resfeber.se>
MIME-Version: 1.0
To: Thuan Minh Tran <tmthuan@tma.com.vn>
CC: msql-mysql-modules@lists.mysql.com
Subject: Re: dirver for perl on linux
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I'm not really sure i understand the question but do you mean DBI?
http://www.cpan.org/modules/by-module/DBI/
/Jon
Thuan Minh Tran wrote:
>
> Hi all,
> I'm looking for a mysql driver for PERL on Linux, please show me where to
> get it.
>
> thanks a lot in advance,
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail msql-mysql-modules-thread1473@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.
["msql-mysql-modules_1474.ezm" (message/rfc822)]
Message-ID: <002001c15d1a$fda20070$9f01a8c0@Jaya>
From: "Rajeev Rumale" <rajeev@myangel.com>
To: <msql-mysql-modules@lists.mysql.com>
Subject: Creating user accounts and assinging previlages
Date: Thu, 25 Oct 2001 14:05:03 +0800
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hello every body,
Recently I could install MYSQL in my win2k machine and create database in it
also. I need to know how I can change the root user password and
previlages, aslo creat new user.
I have followed the instruction given in the manual, but could not find any
change. I am still able to connect without password. I have also installed
the trial version of MASCON for creating and deleting tables etc.,
Kindly let me know the same.
with regards
Rajeev
["msql-mysql-modules_1475.ezm" (message/rfc822)]
CC: join-isp-equipment@lists.isp-lists.com,
join-isp-firewalls@lists.isp-lists.com,
join-isp-bgp@lists.isp-lists.com,
join-isp-webhosting@lists.isp-lists.com,
join-isp-southafrica@lists.isp-lists.com,
isp-france-digest@lists.isp-lists.com,
join-isp-satellites@lists.isp-lists.com,
join-isp-france@lists.isp-lists.com,
join-isp-books@lists.isp-lists.com,
join-isp-reporters@lists.isp-lists.com,
isp-streamingmedia-digest@lists.isp-lists.com,
join-isp-germany@lists.isp-lists.com,
isp-win2k-digest@lists.isp-lists.com,
join-isp-multicasting@lists.isp-lists.com,
update-on@lists.journeys-intl.com,
owner-mol-cancer@lists.kbt.com,
requests@lists.knight-rider.com,
help-oaug-enews@lists.ksinet.com,
join-lawyers@lists.lawbooks.com,
seminary@lists.ldsworld.com,
rbi-trial-sub@lists.lowrisk.com,
nasp-digest-request@lists.ltsi.net,
owner-dfwtalkradio@lists.lyris.net,
unsubscribe-prwebnews@lists.lyris.net,
pmail-addresses-storytellers@lists.maine.com,
y2ktest@lists.mcgill.ca,
wtn-l@lists.mcgill.ca,
budgettravel@lists.mcp.com,
mol-cancer@lists.meds.com,
owner-mplayer_newsletter@lists.mpath.com,
majordomo@lists.mpgn.com,
owner-xsl-list@lists.mulberrytech.com,
xsl-list-digest@lists.mulberrytech.com,
msql-mysql-modules@lists.mysql.com,
win32@lists.mysql.com,
mysql-thread9586@lists.mysql.com,
mansun-music@lists.natts.com,
requests@lists.natural.com
Date: Thu, 25 Oct 2001 22:51:03 -0700
Message-Id: <11gu3y4i5x1t4ojao.0p834gevo18@slip-12-64-223-229.mis.prserv.net>
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: 7BIT
Subject: `Why WAIT??? Refiance NOW!!!
Reply-To: funny453@yahoo.com
To: bradnelson@excite.com
From: nelsonhot@hotmail.com
We can help!
Mortgage Rates have been slashed again!
*Lower your monthly payment!
*Shorten the term of your loan!
*Reduce your interest rate!
SAVE MONEY!!!
NOW is the time to refinance... rates have
NEVER been lower!
We CAN assist everyone, even if you've
been turned down before!
Take just a minute to complete this form
and a Loan Consultant will contact you at
your convenience.
http://www.firstmortgagedebt.com
Your information is secure, confidential and
you are under NO OBLIGATION for this
free analysis.
****************************************************************
Since you have received this message you have either responded
to one of our offers in the past or your address has been
registered with us. If you wish to be removed please reply to:
mailto:wooden5674@yahoo.com?subject=remove
**********************************************************
["msql-mysql-modules_1477.ezm" (message/rfc822)]
From: "Jonathan M. Morgan" <jmorgan9@midsouth.rr.com>
To: <msql-mysql-modules@lists.mysql.com>
Subject: INSERT, UPDATE and Groundhogs
Date: Fri, 26 Oct 2001 10:49:52 -0700
Message-ID: <MBBBLFHBDKJOLIMIJOPHAEONCBAA.jmorgan9@midsouth.rr.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
I am working my way through Paul DuBois' excellent book "MySQL and Perl for
the Web." One of the examples shows how to conduct a poll- vote for your
favorite groundhog: http://www.kitebird.com/cgi-perl/groundhog.pl
Paul then suggests modifying the poll "...to log EACH vote and when it
occurred so that you can perform time-based analysis of poll activity."
How does one tally the vote (UPDATE) and insert a new record for each vote?
The original MySQL table is as follows:
CREATE TABLE
(
name CHAR(10) NOT NULL,
tally INT UNSIGNED NOT NULL DEFAULT 0
)
The vote tally is updated like this:
$dbh->do ("UPDATE groundhog SET tally = tally + 1 WHERE name = ?",
undef, $name);
I updated the table to include an auto incremented vote_id(PRIMARY KEY) as
well as a timestamp. But how do you log each vote and tally the vote?
Thanks!
JMM
["msql-mysql-modules_1478.ezm" (message/rfc822)]
Content-Type: text/plain;
charset="iso-8859-1"
From: Andreas Gietl <a.gietl@e-admin.de>
To: "Jonathan M. Morgan" <jmorgan9@midsouth.rr.com>,
<msql-mysql-modules@lists.mysql.com>
Subject: Re: INSERT, UPDATE and Groundhogs
Date: Fri, 26 Oct 2001 18:14:52 +0200
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <E15x9cI-0005Fd-00@d101.x-mailer.de>
On Friday 26 October 2001 19:49, Jonathan M. Morgan wrote:
just set up anothter table and do an insert for every vote into that table.
> I am working my way through Paul DuBois' excellent book "MySQL and Perl for
> the Web." One of the examples shows how to conduct a poll- vote for your
> favorite groundhog: http://www.kitebird.com/cgi-perl/groundhog.pl
> Paul then suggests modifying the poll "...to log EACH vote and when it
> occurred so that you can perform time-based analysis of poll activity."
>
> How does one tally the vote (UPDATE) and insert a new record for each vote?
>
> The original MySQL table is as follows:
>
> CREATE TABLE
> (
> name CHAR(10) NOT NULL,
> tally INT UNSIGNED NOT NULL DEFAULT 0
> )
>
> The vote tally is updated like this:
>
> $dbh->do ("UPDATE groundhog SET tally = tally + 1 WHERE name = ?",
> undef, $name);
>
> I updated the table to include an auto incremented vote_id(PRIMARY KEY) as
> well as a timestamp. But how do you log each vote and tally the vote?
>
> Thanks!
>
> JMM
>
>
>
>
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail
> msql-mysql-modules-thread1477@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.
--
e-admin internet gmbh
Andreas Gietl
Roter-Brach-Weg 124a
tel +49 941 3810884
fax +49 941 3810891
mobil +49 171 6070008
["msql-mysql-modules_1479.ezm" (message/rfc822)]
From: Michael Widenius <monty@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <15320.4420.945582.71105@tramp.mysql.fi>
Date: Thu, 25 Oct 2001 16:19:00 +0300 (EEST)
To: Bill Adams <badams@tqs.com>
Cc: MySQL Bugs <bugs@lists.mysql.com>, msql-mysql-modules@lists.mysql.com
Subject: Apache/mod_perl/DBI/MySQL 4.0 alpha
Reply-To: monty@mysql.com
Hi!
>>>>> "Bill" == Bill Adams <badams@tqs.com> writes:
Bill> Not sure this is the right place to report this...
Bill> This bug only happens when using Apache
Bill> + mod_perl + DBI + MySQL 4.0 alpha. When trying
Bill> to fetch a row (it does not matter which
Bill> fetchrow_* function is called) the call returns an
Bill> error: "dbih_setup_fbav: invalid number of fields:
Bill> 0, NUM_OF_FIELDS attribute probably not set right
Bill> at ...". This problem does not happen when
Bill> Msql-mysql-modules is linked against the 3.23.41
Bill> libmysqlclient.so.
Before checking this further, could you please verify that you
have recompiled DBD-mysql with the new MySQL 4.0 header files ?
We added in 4.0 some new fields to the MYSQL struct that could cause
problems like this if one uses the new libmysql libraries without
recompiling.
Regards,
Monty
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic