Re: Blasted #$%$^$^ host has v3.23 when i need UNION

You may also want to look at http://www.php.net/manual/en/function.mysql-num-rows.php Ryan A wrote: Hey, Thanks for replying. Nope, the whole reason for selecting the data is the count, i need to display to the client how many records of each category he has...if there is any other way to do that

Dates

I am in the process of porting some python scripts to Mysql. Currently, the scripts I have queries a Pg database for entries (made) between certain dates. The python script snippet of the query mainQuery = select distinct

Re: Dates

Joseph Bueno wrote: . . . rt3=# select age(now(),'2003-08-26'::timestamp); age 6 days 10:14:43.421275 +++ Thanks, and select age('2003-08-26',resolved) where 'resolved' is a 'timestamp'. -- MySQL General Mailing List For list

Benchmark

I have the following setup : Apache 2 + mod_perl 2 mysql 3.23.54 I need to is measure the perfomance of a ticketing system (written in perl)which has web interface (html::mason, apache2) with Mysql as a backend. Users of the ticketing system can only connect to the backend via the web interface

Perfomance Tuning

I have just installed redhat linux 9 which ships with mysql 3.23.56. Mysql has to be setup so that it can use innodb tables, and data inserts (blobs) should be able to handle at least 8M at a time. The machine has two P III 933MHz CPU's, 1.128G RAM (512M*2 + 128M), and a 36 Gig hd with 1 Gig swap

Re: Rewrite

Would table names still be case sensitive if the connection is done through odbc? Diana Soares wrote: Read the first item that appears in MySQL manual if you search for case sensitivity: http://www.mysql.com/doc/en/Name_case_sensitivity.html -- MySQL General Mailing List For list archives:

Rewrite

How can I write this query so it works on mysql 3.54: select groupmembers.memberid,users.name from groupmembers,users where (not users.name='root') and groupmembers.groupid=(select groups.id from groups where groups.type='Privileged')

Re: Innodb table full

The size is already set to 2000M, and I may be wrong, but the autoextend feature is not support in mysql version earlier that 4. Nils Valentin wrote: Hi Mixo, Do you have the autoextend feature enabled for the innodb table ? It can be set f.e in my.cnf. Best regards Nils Valentin Tokyo/Japan

Ideal setup

Perfomance matters the most. So, what would be the ideal setup for permomance in Mysql? Machine specs: PIII 1.0 GHz 640 MB Ram 36 Gig Hd partions as follows: /dev/sda1 linux swap1 Gig

Benchmarking

How can I benchmark the perfomance of Mysql with the following setup: Perl 5.8.0 (perl-DBI, perl-DBI-Mysql) mysql-3.23.54a-11 apache-2.0.40-21 mod_perl-1.99_07-5 I want to compare the perfomance of Mysql against that of Pg using my own data. And, how can I resolve : DBD::mysql::st execute

Innodb table full

How can I avoid this: DBD::mysql::st execute failed: The table 'Transactions' is full at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm The table type is InnoDB. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

mysql 'enum' column values

Is there a way I can get what the allowed values of an 'enum' coulmn are in mysql? I want to eventually list these values in a list box or something similar? - Before posting, please check: http://www.mysql.com/manual.php

entry just made in mysql table

sql,query Is there a way to find out what the value of the last entry just made in a mysql table where the field is being auto incremented? - Before posting, please check: http://www.mysql.com/manual.php (the manual)