Re: comparision of performance b/w mysql and db2

Anirudha, AK> could anybody please send me some details showing the performance of the AK> mysql server usder varying loads as compared to db2 server Take a look: http://www.mysql.com/doc/en/MySQL_Benchmarks.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH

Re: comparision in the datetime field

Use: select * from table where date_col between 'xxx' and 'yyy'; You need to replace XXX and YYY with the dates you want like '2003010430' for January 04, 2003, 11:11:30. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: "aman raheja" <[

re: comparision in the datetime field

At 15:07 +0200 1/4/03, Egor Egorov wrote: On Friday 03 January 2003 19:25, aman raheja wrote: I have a datetime field in one of my tables in the MySQL database. Can I do something like return all records between two certain dates, say between Nov 02, 2002 and Nov 07, 2002. SELECT .. WHERE m

re: comparision in the datetime field

On Friday 03 January 2003 19:25, aman raheja wrote: > I have a datetime field in one of my tables in the MySQL database. > Can I do something like return all records between two certain dates, say > between Nov 02, 2002 and Nov 07, 2002. SELECT .. WHERE mydatefield BETWEEN '2002-11-02 00:00:00' A

Re: Comparision

http://www.phpbuilder.com/columns/tim2705.php3 Altough it's NOT done with the latest versions of each DB. (He says that mySQL can't do transactions, well it does now with innoDB) (I think the max concurrent connections setting wasn't changed so that's why his mySQL was craching after 100 con