RE: group by error in query

2001 10:54 To: Daniel Kirk; [EMAIL PROTECTED] Subject: Re: group by error in query On Wed, Mar 21, 2001 at 07:31:20PM +1100, Daniel Kirk wrote: > Hi, > > I've just ported from SQLServer where this query ran fine, however MySQL > gives an "invalid use of group function" er

RE: group by error in query (RESEND, don't think it came through)

Hi, I've just ported from SQLServer where this query ran fine, however MySQL gives an "invalid use of group function" error. Any ideas? thx dan select us.username, us.id as userid, count(*) as tips from UserTippingInfo u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND m.match

group by error in query

Hi, I've just ported from SQLServer where this query ran fine, however MySQL gives an "invalid use of group function" error. Any ideas? thx dan select us.username, us.id as userid, count(*) as tips from UserTippingInfo u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND m.match

importing data into a table with auto_increment

hi there, is there a problem with importing data into a table with an auto_increment field with a primary key, if the data contains values for the auto_increment field? I keep getting an error that it can't insert the value "1" more than once. However, all the values for the auto_increment fiel

from SQLServer7 to MySQL

Does anyone know of any good resources on converting an SQLServer7 database to MySQL? In particular, what's the best method of copying the data (about 150MB over 10 000 kilometres), and do any changes need to be made to datatypes? thx for any info or pointers to resources Dan ---

RE: INDEX() / UNIQUE()

on a related but slightly different example, what would happen if you had a Primary Key consisting of 2 columns a & b (so the pkey enforces a unique combination of a & b) and then created an index on one of the columns eg b. Would the index on b have any effect, or does a primary key on 2 columns

RE: MySQL Memory Requirements...

vek Khera [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 February 2001 08:39 To: [EMAIL PROTECTED] Subject: RE: MySQL Memory Requirements... >>>>> "DK" == Daniel Kirk <[EMAIL PROTECTED]> writes: DK> 30gb eide hdd DK> Will the machine fall over because it doesn&

RE: MySQL Memory Requirements...

/CPU power (for about 20k users per week as below)? any ball park comments eg no worries, close call, not a chance? thx dan -Original Message----- From: Daniel Kirk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 February 2001 09:38 To: [EMAIL PROTECTED] Subject: MySQL Memory Requirements... Can

RE: amazingly slow

i've heard it said that every so often (eg every month) you need to rebuild indexes on tables, as over time they lose their performance enhancement. could that be true? dan -Original Message- From: Tim Samshuijzen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 February 2001 04:50 To: [EMAI

MySQL Memory Requirements...

Can someone please give me a rough estimate of how much RAM MySQL would require to run something like : A connection pool of around 50 connections 20,000 users every week re-using these 50 connections around 50 inserts per user (each row around 30 bytes) around 20 queries per user Installation on

any recommendations

any recommendations for jdbc drivers running red hat? which version of red hat should i install - 6.2 or 7? thx for advice dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

date/time functions

Does MySQL have any date/time functions -> can anyone give me a URL where I can find some documentation on it. I'm looking for SQLServer equivalents of DateAdd(), DateDiff(), Month(), Year() etc thx dan - Before posting, pleas

when does inserting become too much of an overhead?

Hi there, I am considering porting a MS-SQLServer database to MySQL. After reading some of the documentation, I am concerned about inserts. I run a sports prediction website, where players submit their predictions for a competition. When a player submits their predictions, this is generally 10