Weird result on max compared to order by

Hi, I did a select on a primary key.. Select max(account_id) from mytable; -- it gave me a value X I did a select with order by Select account_id from mytable order by account_id desc limit 3 -- it gave me a value of Y ( Y is the right value ) I was wonderin

RE: [SPAM] - MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint... - Email found in subject

http://blogs.ittoolbox.com/km/sharepoint/archives/sharepoint-and-mysql-2 2051 hmm.. but I think you might have problems getting support from sharepoint's vendor... IIRC they always push to use SQL server for this.. (we know the reason why.. :) ) >-Original Message- >From: Jacob,

RE: [SPAM] - Re: Sun and mysql - Email found in subject

>-Original Message- >From: Olaf Stein [mailto:[EMAIL PROTECTED] >Sent: Thursday, January 17, 2008 12:13 PM >To: Peter (MySQL List); MySql >Subject: [SPAM] - Re: Sun and mysql - Email found in subject > >You have a point. >But, facebook makes NO money

RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject

I was lurking on Sun's website.. they are also carrying PostgreSQL in their line of products.. Great!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:07 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject

RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject

Oracle and Sun has a tight relationship right? Wouldn't there be a conflict of interest? -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:03 AM To: [EMAIL PROTECTED] Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: [SPAM] -

RE: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject

Big fish eats the small fish.. :) Will this bring good things to MySQL? -Original Message- From: John Meyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 8:58 AM To: Brett Harvey; mysql@lists.mysql.com Subject: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject Bre

RE: Unable to restart after crash

Or maybe the pid is still existing? -Original Message- From: Ross Crawford [mailto:[EMAIL PROTECTED] Sent: Saturday, January 12, 2008 5:13 PM To: mysql@lists.mysql.com Subject: Unable to restart after crash Hi, My mysql server crashed last night, and when it rebooted, was unable to res

RE: Securing the Data

Hmmm most likely developers will have a way to get that "pass_str" since they are the Developers.. :) -Original Message- From: Jimmy Guerrero [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 3:35 PM To: Sujatha S Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: Re: Securi

RE: Securing the Data

You can limit access to tables in a database using a specific login.. Read on GRANT -Original Message- From: Sujatha S [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 3:06 PM To: mysql@lists.mysql.com Subject: Securing the Data Hello, Is it possible to encrypt data on mys

RE: Red Hat EL and Datbase Setup

Try reading on RAID1+0, though it's a bit expensive in implementation but its great on READ & WRITE.. Basing on the current stable version there is no built in table partitioning.. you can do it in an application level.. -Original Message- From: Jason Vinar [mailto:[EMAIL PROTECTED] Sen

RE: High Traffic Sites

Hi, There are a lot of clustering you techniques you can use. Read on livejournal attack on this problem. You need to start from the schema poorly constructed schema will kill your hardware. Go to Mysql Site search for whitepapers and friendster (I'm not saying it the best implementation