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

comparision of performance b/w mysql and db2

i am planning to shift my database from mysql to db2 could anybody please send me some details showing the performance of the mysql server usder varying loads as compared to db2 server thanks! - Before posting, please check: h

Re: comparision in the datetime field

al Message - From: "aman raheja" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Friday, January 03, 2003 7:25 PM Subject: comparision in the datetime field Hi All I have a datetime field in one of my tables in the MySQL database. Can I do something li

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

comparision in the datetime field

Hi All 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. Thanks Aman - Before posting, please check:

Re: Comparision

gt; I would appreciate if someone could let me know pros and cons of using these > databases. Is there a comparision information available for MySQL and > PostgreSQL? > > Thanks, > > jasvinder > > - >

Comparision

Hi DB Gurus, I am planning to use database for one of my applications. I need to decide between MySQL and PostgreSQL. I would appreciate if someone could let me know pros and cons of using these databases. Is there a comparision information available for MySQL and PostgreSQL? Thanks, jasvinder

Re: Re: String Comparision

On Mon, 26 Nov 2001, Marjolein Katsma wrote: > Paul, > > At 16:56 2001-11-25 -0600, Paul DuBois wrote: > >database,sql,query,table > > > >At 7:40 PM +0100 11/25/01, Marjolein Katsma wrote: > >>At 12:19 2001-11-25 -0600, Paul DuBois wrote: > select * from users where dbname= "Brain" returns

Re: Re: String Comparision

Paul, At 16:56 2001-11-25 -0600, Paul DuBois wrote: >database,sql,query,table > >At 7:40 PM +0100 11/25/01, Marjolein Katsma wrote: >>At 12:19 2001-11-25 -0600, Paul DuBois wrote: select * from users where dbname= "Brain" returns both "brain" and "Brain". I read section 6.3.2.2 and s

Re: Re: String Comparision

database,sql,query,table At 7:40 PM +0100 11/25/01, Marjolein Katsma wrote: >At 12:19 2001-11-25 -0600, Paul DuBois wrote: >>>select * from users where dbname= "Brain" returns both "brain" and "Brain". >>> >>>I read section 6.3.2.2 and select binary dbname from users where >>>dbname="brain" also

Re: String Comparision

At 12:19 2001-11-25 -0600, Paul DuBois wrote: select * from users where dbname= "Brain" returns both "brain" and "Brain". I read section 6.3.2.2 and select binary dbname from users where dbname="brain" also returns both records. SELECT dbname FROM users WHERE BINARY dbname = "brain" perhaps?

Re: String Comparision

At 11:23 PM -0500 11/24/01, Gary Huntress wrote: >I have a table of user info containing mixed case text. One user has >created a database named "brain" and another has created a database "Brain". >I was surprised to see that: > >select * from users where dbname= "Brain" returns both "brain" and

String Comparision

I have a table of user info containing mixed case text. One user has created a database named "brain" and another has created a database "Brain". I was surprised to see that: select * from users where dbname= "Brain" returns both "brain" and "Brain". I read section 6.3.2.2 and select binary db