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
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
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
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
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
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:
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')
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
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
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
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:
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
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)
13 matches
Mail list logo