SQL Statement Help - Is this possible?

2003-12-10 Thread Mark Marshall
I have a database table that has one row entered every day by the user. If the user skips a day, it throws off our monthly totals. Assume a table with four columns: id (which is the key), date (-mm-dd), data1 (int), data2 (int) Is there a way to say Select the first missing date in the

Re: Status shows wrong version number for server after upgrade

2003-11-21 Thread Mark Marshall
/sbin /bin -name mysqld to see whether there is more than one copy of mysqld hanging around. Regards, Thomas Spahni On Wed, 19 Nov 2003, Mark Marshall wrote: I just compiled 4.0.16 and installed it over top of 4.0.4 beta. After stopping and restarting mysqld_safe, I went into mysql

Why does -1 show up as 18446744073709551613?

2003-11-20 Thread Mark Marshall
I've been running this query for quite some time that basically says: SELECT (A + B + C) - (X + Y + Z) AS Variance FROM . Up until now, this has been working correctly and showing up as anything from -100 to +100. Now all of a sudden, it's showing up as 18446744073709551613 instead of

Re: Why does -1 show up as 18446744073709551613?

2003-11-20 Thread Mark Marshall
operations (like +) and one of the operands is unsigned integer, the result will be unsigned. You can override this by using the SIGNED and UNSIGNED cast operators... Mike On Thursday 20 November 2003 17.10, Mark Marshall wrote: I've been running this query for quite some time that basically says

Need Help Upgrading From 4.x to 4.x

2003-11-19 Thread Mark Marshall
Hi, everyone. I have a 4.0.4 beta install of Mysql on Red Hat 7.3. I want to upgrade it to 4.0.16, and keep all the data intact. Do I just dump the databases (just in case), stop the server, then ./configure, make, make install over top of the old server and start it up again and see what

Status shows wrong version number for server after upgrade

2003-11-19 Thread Mark Marshall
I just compiled 4.0.16 and installed it over top of 4.0.4 beta. After stopping and restarting mysqld_safe, I went into mysql and issued a status command. I got back the following: mysql status -- mysql Ver 12.22 Distrib 4.0.16, for pc-linux (i686) Connection id: 35

Re: sub queries

2001-01-18 Thread Mark Marshall
]![Gen_OneFacility]![StartDate] Or [CensusData]![Date]=[Forms]![Gen_OneFacility]![EndDate])))False)) ORDER BY CensusData.Date; Ryan Wahle [EMAIL PROTECTED] 01/16/01 04:51PM What's your subquery and we can help you convert it to a join. On 16 Jan 2001 15:59:48 -0500, Mark Marshall wrote: Hi all

sub queries

2001-01-16 Thread Mark Marshall
Hi all, Is there any kind of schedule that says when the next MySQL version will be available? I'd like to utilize MySQL here, but I can't really start to seriously work on it until sub-queries are possible. Thanks! Mark -