grouping

Hi, I want to use: select column1, column2, max(column3) as maximum from table_name group by column 1; Please tell me if the values from column2 will contain the values from those records where the column3 has the maximum value. If it doesn't, please tell me how to do this as fast as

need a help in Query

Hi Fello MySQL users, I am Bala Raju, i have a problem to extract data by writing query, i need u r help. Please help me. I have two tables, i am giving the tables as attachement, firs table is playersloginfo and second one is playerhanddetails. playersloginfo : This table stores all the

Re: need a help in Query

On Saturday 10 February 2007 12:45, balaraju mandala wrote: Hi Fello MySQL users, I am Bala Raju, i have a problem to extract data by writing query, i need u r help. Please help me. I have two tables, i am giving the tables as attachement, firs table is playersloginfo and second one is

mysql_upgrade shows errors

Hello, I noticed that the current MySQL 5.0 release is not available as binary, so I downloaded the source and compiled it on my testing machine. Compilation went fine and I can connect to the new MySQL server version. But then I tried to run the mysql_upgrade script to fix possible issues and

Re: grouping

select column1, column2, max(column3) as maximum from table_name group by column 1; Please tell me if the values from column2 will contain the values from those records where the column3 has the maximum value. They will not. please tell me how to do this as fast as possible. What's fastest

Re: need a help in Query

Hi Jorn, Thank you for reply, of course i can merge the columns and change the datatype. But buddy that is not problem here, the problem is extract the data. Did u able to understand my language, if not i will explain you again. Please read the mail again and tell some ways from u r experience.

Re: need a help in Query

On Saturday 10 February 2007 19:21, balaraju mandala wrote: Hi Jorn, Thank you for reply, of course i can merge the columns and change the datatype. But buddy that is not problem here, the problem is extract the data. After reading your message once more, I realise that you should do even

Table definitions not accepting data as defined...

OK - this has me TOTALLY stumped. I am running into cases where table definitions are somehow not working. I have a variable in a table defined: price decimal(5,2) Recently we moved servers, all of a sudden, this definition seems to read that the TOTAL length of that field is 5, not the

to join or not to join, that is the query

Hi, i am having some difficulty to write a query for the following problem: I have three tables: TABLE Person - id_person, name, id_levelA, id_sizeA, id_levelB, id_sizeB TABLE Levels - id, desc TABLE Sizes - id, desc

Capacity/Load question

Hello, Just looking for a little feedback before deciding on a data engine path and configuration. We're working on an application that is expected to have a high growth rate over the coming years. We're at the stage of designing the backend databases to maximize performance while keeping

Password on DB Files not on DB server

Hi, I am sure this is been asked many times before, but seems like I could not find answer to it so here you go, Is there any way to put password on Data base(files) itself rather than DB server? If yes how to achive it? If no, any suggestions which db support that? Thank you in advance!

Re: Password on DB Files not on DB server

At 10:49 PM 2/10/2007, Suhas Pharkute wrote: Hi, I am sure this is been asked many times before, but seems like I could not find answer to it so here you go, Is there any way to put password on Data base(files) itself rather than DB server? See the Grant command to set up users where you can

Re: Password on DB Files not on DB server

This is true, if the db is still on same db server. Correct me if I am wrong, but it will not protect if some body copies the files to other DB server, then they can see the DB Suhas On 2/10/07, mos [EMAIL PROTECTED] wrote: At 10:49 PM 2/10/2007, Suhas Pharkute wrote: Hi, I am sure this is

Re: Password on DB Files not on DB server

This is true, if the db is still on same db server. Correct me if I am wrong, but it will not protect if some body copies the files to other DB server, then they can see the DB Suhas On 2/10/07, mos [EMAIL PROTECTED] wrote: At 10:49 PM 2/10/2007, Suhas Pharkute wrote: Hi, I am sure this is

Re: Password on DB Files not on DB server

This is true, if the db is still on same db server. Correct me if I am wrong, but it will not protect if some body copies the files to other DB server, then they can see the DB Suhas