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
/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
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
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
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
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
]![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
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
-