Thanks,
That did it!
> -Original Message-
> From: Daniel Staal [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 27, 2004 11:36 AM
> To: Perl Beginners
> Subject: RE: perl mysql question
>
> --As of Tuesday, April 27, 2004 8:30 AM -0700, Christopher Lyon is
a
--As of Tuesday, April 27, 2004 8:30 AM -0700, Christopher Lyon is alleged
to have said:
while ( @array = $sth->fetchrow_array() ) {
print "$array[1] -> $array[3]\n";
$table{ "$array[1]" } = "$array[3]";
}
my @keys = keys( %table ) ;
while ( $key = pop( @keys ) ) {
print "
> -Original Message-
> From: Daniel Staal [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 26, 2004 8:54 PM
> To: Perl Beginners
> Subject: Re: perl mysql question
>
> --As of Monday, April 26, 2004 5:30 PM -0700, Christopher Lyon is
alleged
> to have said:
>
Christopher Lyon wrote:
> 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:
>
[snip]
>
> I need to take the names and add the counts up for between each table
>
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
Wi
--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
Wi
>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,
