Re: Confused on Query's

I assume each part can be associated with multiple projects, which is a many to many relation. In that case you need to create a "join" table that holds the relation. Table like that are typically just 2 fields, one for the project id and one for the part id. You may want to add other field

Re: Access denied for user on Windows Server

Car Toper wrote: > More info... > > I am able to login with the account via phpMyAdmin on the server. > Also, I am trying to use phpMyAdmin to change the permissions, but I > cannot figure out the syntax: > > GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION; > > Cartoper > > On 8/21/07

RE: Why is the average of an int column returned as a string

I have tried that and that seems to be working for me. I am just wondering why all of the sudden queries that were returning the averages as numeric values as string values. Thank you for your suggestion. Thank you Eric H. Lommatsch Programmer 360 Business 2087 South Grant Street Denver, CO

Confused on Query's

lets say u have a table called Parts and another called Projects ,,, how can u associate the Parts Table with the Projects table so lets say u wanna add a Specific Part to a project maybe even add three parts from the parts table and associate it with a specific project ??? so maybe u would

Re: MYSQL ENTERPRISE AND COMMUNITY

AFAIK the only difference is support and the availability of the enterprise source code (this changes recently) On 8/22/07 4:10 PM, "krishna chandra prajapati" <[EMAIL PROTECTED]> wrote: > Hi Stein, > > I have gone through the link provided below. But still i have the question > that, whether t

Re: MYSQL ENTERPRISE AND COMMUNITY

Hi Stein, I have gone through the link provided below. But still i have the question that, whether the mysql database software provided in enterprise edition is same as community edition or some other features is there. Regards, Krishna On 8/23/07, Olaf Stein <[EMAIL PROTECTED]> wrote: > > http

RE: Left join is not doing what I thought it should do.

By using AND, you've moved the test for 79760 into the JOIN condition. I wouldn't have thought of that, either. This seems to be a peculiarity of a LEFT JOIN. Normally, if you compare a NULL value against anything, even another NULL, the result is NULL (neither true nor false). I don't understand w

Re: MYSQL ENTERPRISE AND COMMUNITY

http://www.mysql.com/products/which-edition.html On 8/22/07 3:13 PM, "krishna chandra prajapati" <[EMAIL PROTECTED]> wrote: > hi all, > > I am confused about community and enterprise mysql server. Whether software > for both is free or enterprise comes with additional features. > Please give me

Re: Left join is not doing what I thought it should do.

It works if I do AND instead of WHERE Go figure LEFT JOIN friends ON gameLeaderboards.userID = friends.userB AND friends.userA = 79760 -- Dave Jerry Schwartz wrote: I think your problem is that you can't have a "missing" friends record that also has a non-null value for friends.userA. If frien

MYSQL ENTERPRISE AND COMMUNITY

hi all, I am confused about community and enterprise mysql server. Whether software for both is free or enterprise comes with additional features. Please give me the details. regards, Krishna

RE: Left join is not doing what I thought it should do.

I think your problem is that you can't have a "missing" friends record that also has a non-null value for friends.userA. If friends.userA = 79760, then you've found a record. You can have records where userA is something valid and UserB is null, but then you can't join on UserB. Does that help?

Left join is not doing what I thought it should do.

I have 3 tables A users table (userID, userName) A leaderboard table (userID, score) A friends table (userIDA, userIDB) I would like to produce the following result: userName, score, userIDA Dave, 100, 1 Simon, 200, 5 Paul, 300, NULL The 3rd record is NULL as there is no record in "friends" wit

Re: How to limit word result by query

At 12:40 AM 8/22/2007, [EMAIL PROTECTED] wrote: Hi all, Is it possible to do query which limiting the result into some words only? i.e the complete sentence is "I am able to login with the account" and I just want to view "I am able to login..." Many thanks for any reply. Regards, Willy Will

Re: MySql priority

You may want to consider tuning the 'his-priority' server instance by giving it larger values for the following: temp_table_size query_cache_size query_cache_limit Ben Clewett <[EMAIL PROTECTED]> wrote: Sorry if this has been asked many times before... I have 5 MySql systems running

MySql priority

Sorry if this has been asked many times before... I have 5 MySql systems running on a single server. I want one to run with maximum priority, the other four to run with minimum. Can this me archived using something as simple as 'nice': # nice -10 mysqld --defaults-file=his_priorty # nice 10 my

RE: Why is the average of an int column returned as a string

You could use the CAST function, although I have just discovered that MySQL is rather limited in the types you are able to CAST to... http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html -Original Message- From: Eric Lommatsch [mailto:[EMAIL PROTECTED] Sent: 21 August 2007 22:52 To: