On 7/21/06, Karjala [EMAIL PROTECTED] wrote:
Maybe I should ask this question on a database list, but it's related to
DBI, so I'm asking here also:
I have a field in a record in the MySQL database that contains a number.
I increase it by one with $dbh-do(update table set myfield = myfield +
1
Maybe I should ask this question on a database list, but it's related to
DBI, so I'm asking here also:
I have a field in a record in the MySQL database that contains a number.
I increase it by one with $dbh-do(update table set myfield = myfield +
1 where mykey = 10);
I was wondering whether
: Friday, July 21, 2006 7:54 PM
To: beginners@perl.org
Subject: MySQL question
Maybe I should ask this question on a database list, but it's related to
DBI, so I'm asking here also:
I have a field in a record in the MySQL database that contains a number.
I increase it by one with $dbh-do(update
--As of Monday, May 24, 2004 8:43 AM +0600, LRMK is alleged to have said:
By the way is PostgreSQL free and if yes where can I get a copy to
practise myself.
--As for the rest, it is mine.
Yes: http://www.postgresql.org/
Daniel T. Staal
- Original Message -
From: Randal L. Schwartz [EMAIL PROTECTED]
To: LRMK [EMAIL PROTECTED]
Sent: Friday, May 21, 2004 9:24 PM
Subject: Re: A MySQL Question
If you have an actual database (not MySQL, but something modern like
PostgreSQL or Oracle
On Fri, 21 May 2004, LRMK wrote:
Probably this is not relavent to this mailing list... But any way I ll ask..
I am developing a web site traffic rating system. using a combination og
perl and java (PERL in serverside, Java Applets in cliend side - My attempt
to create dynamic images was not
Rotators
- Original Message -
From: Dani Pardo [EMAIL PROTECTED]
To: LRMK [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, May 21, 2004 1:06 PM
Subject: Re: A MySQL Question
On Fri, 21 May 2004, LRMK wrote:
Probably this is not relavent
On Fri, 21 May 2004, LRMK wrote:
I dont like to remove the RANK field onless there is no other solution
becouse this Rating system going to be used by a community of people to
messure the performance of their web sites compaired to others the RANK must
be there.
I am thinking about
the number of queries?
I know if I use Oracle db i can make a PL/SQL procedure but my web host only
give MySql
Question 2 ) Can I make functions with mySQL if yes where can I find a
tutorial?
Hi.
I would keep the rank values in a separate table with just two columns: the
domain name
in the table there going
to 1501 queries (there going to be lots mor records than 1500 in the real
system)
Question 1 ) Is there a more efficiant way of doing this, atleast to reduce
the number of queries?
I know if I use Oracle db i can make a PL/SQL procedure but my web host only
give MySql
Question 2
Not sure if I should post this to beginners or not but there it goes.
I have 10+ tables with some of the same information in each in table of a mysql
database. Here is an example:
Table 1
namecount
-+---
Widgets-A| 10
Widgets-B| 5
Widgets-C| 10
--As of Monday, April 26, 2004 5:30 PM -0700, Christopher Lyon is alleged
to have said:
So, how to I get the values to look like in variable so that I can push
them back into a new table:
New Table
namecount
-+---
Widgets-A| 25
Widgets-B| 10
Widgets-C| 20
On 4/26/2004 11:53 PM, Daniel Staal wrote:
--As of Monday, April 26, 2004 5:30 PM -0700, Christopher Lyon is
alleged to have said:
So, how to I get the values to look like in variable so that I can push
them back into a new table:
New Table
namecount
-+---
Widgets-A|25
Hello Fellow Members,
Howdy
I am new to perl and Mysql. I want to set up a mysql table to
take Email addresses, and randomly place them into a payment
button from PayPal, and StormPay.
Can anyone tell me how to write the script to setup the MySql
Table to do this.
Sure, you
On Wed, 27 Aug 2003 09:25:03 -0500, Dan Muey [EMAIL PROTECTED] wrote:
Hello Fellow Members,
Howdy
I am new to perl and Mysql. I want to set up a mysql table to
take Email addresses, and randomly place them into a payment
from it.
Either way, get the data and put it in your form.
HTH
DMuey
Thanks in Advance
Dan
- Original Message -
From: Dan Muey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 10:25 AM
Subject: RE: Mysql Question. Can Someone Help
Hello Fellow
Hi,
Howdy
I have a php form that takes in data for a mysql query. The
script that
processes the form takes the variables from the form and
submits them to
the db.
What if the field after LIKE needs to be imprecise? The variable
somehow needs to be converted to a regular
Hi,
I have a php form that takes in data for a mysql query. The script that
processes the form takes the variables from the form and submits them to
the db.
What if the field after LIKE needs to be imprecise? The variable
somehow needs to be converted to a regular expression like /'%expr%'/
Why are you posting this to a perl list? Try [EMAIL PROTECTED]
On Thursday, April 3, 2003, at 06:06 PM, Robbie Staufer wrote:
Hi,
I have a php form that takes in data for a mysql query. The script
that processes the form takes the variables from the form and submits
them to the db.
What
Does any one happen to know if it's possible to do a query within a query :
For instance :
This is for demonstartion purposes and is not executable code :
prepare $sth -$dbh...
execute $sth -$dbh
$sth -$dbh fetchrowarray {
$sth2 -$dbh prepare
$sth 2-$dbh execute
$sth 2-$dbh
Answer my own question. Yes it is possible, no problem.
My problem was an obscure infinite loop. So nevermind!
Thanks
Dan
-Original Message-
From: Dan Muey
Sent: Tuesday, December 31, 2002 1:43 PM
To: [EMAIL PROTECTED]
Subject: dbi mysql question
Does any one happen to know if it's
In my script, I do the following: I insert x amount of records into a MySQL
table, process the information and then delete those records. One of the
columns is an autonumber type so it starts at 1 for instance. In my query
string I use placeholders. Now sometimes the field which is an autonumber
From the MySQL docs:
If you delete the row containing the maximum value for an AUTO_INCREMENT column, the
value will be reused with an ISAM, or BDB table but not with a MyISAM or InnoDB table.
If you delete all rows in the table with DELETE FROM table_name (without a WHERE) in
AUTOCOMMIT mode,
Below is a mysql approach using DBD::Mysql which can be generalized to
DBI pretty easily.
#!/usr/bin/perl
use Mysql;
# connect
if (!($dbh=Mysql-connect('localhost','databasename'))) {print
Connect error. Please try back later.;exit;}
#sample query
$statement=SELECT id,name,location,setting
24 matches
Mail list logo
