Albert,
Your spec isn't entirely clear to me (eg if sd1 sd2 were 'unique
within each record', wouldn't there be zero rows where sd1=sd2?), but is
this what you're looking for ...
SELECT
zz,
COUNT(zz) as zzCount,
SUM(IF(zz=sd1 AND sd1=sd2, 1, 0)) AS sd1sd2Count
FROM ss
GROUP BY zz;
Peter
On Jul 22, 2005, at 6:22 PM, Bruce Dembecki wrote:
So it appears I am having an issue with 4.1.13 which I'm guessing
is a bug... wanted some input before I file it...
Setting up a new machine to take over for an old one, so it's
clean, Operating System and some empty disks... the server
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop mysql from trying to
I am all most ready to give up on MySQL at this point. I'm still
getting regular table corruption on multiple installs of OS X.
I went as far as reporting it as a bug:
http://bugs.mysql.com/bug.php?id=12066
They seem to want more info but my requests for clarification have
gone
Using mysql 3.23 on Red Hat 9.0 partition,
mysql 4.0.20 on Slack 10.0 partition.
I have reviewed some code for a lisp mysql library using
the Foreign Function Interface (exposing the C API).
the shared object referenced in the code is libmySQL.so.
I am not able to locate a file with that
On Jul 23, 2005, at 11:56 AM, Dan Tappin wrote:
I am all most ready to give up on MySQL at this point. I'm still
getting regular table corruption on multiple installs of OS X.
I went as far as reporting it as a bug:
http://bugs.mysql.com/bug.php?id=12066
They seem to want more info but my
I suspect a case problem
ln -s /usr/lib/dbd/libmysql.so libmySQL.so # perhaps?
/opt/lampp/lib/mysql/libmysqlclient.14.0.0
/opt/lampp/lib/mysql/libmysqlclient.14
/opt/lampp/lib/mysql/libmysqlclient.so.14
/opt/lampp/lib/mysql/libmysqlclient.so.14.0.0
/opt/lampp/lib/mysql/libmysqlclient.so
Gregory Machin wrote:
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop
On Jul 23, 2005, at 10:14 AM, Ware Adams wrote:
Has your mysql crashed or have your restarted the machine without
first shutting down mysql manually? We only saw this error when
mysql was not shut down normally. You can look in your .err file
which should be in your data directory.
* sol beach [EMAIL PROTECTED] [050723 09:15]:
I suspect a case problem
Hello sol:
I'm using a case insensitive seach.
i.e.:
[EMAIL PROTECTED] tim]$ locate -i libmysql.so
[EMAIL PROTECTED] tim]$
same results as root
thanks
tim
--
Tim Johnson [EMAIL PROTECTED]
On Jul 23, 2005, at 1:58 PM, Dan Tappin wrote:
On Jul 23, 2005, at 10:14 AM, Ware Adams wrote:
Has your mysql crashed or have your restarted the machine without
first shutting down mysql manually? We only saw this error when
mysql was not shut down normally. You can look in your .err
* Tim Johnson [EMAIL PROTECTED] [050723 10:42]:
* sol beach [EMAIL PROTECTED] [050723 09:15]:
I suspect a case problem
Hello sol:
I'm using a case insensitive seach.
i.e.:
[EMAIL PROTECTED] tim]$ locate -i libmysql.so
[EMAIL PROTECTED] tim]$
Needed libdbi-0.6.5-5.i386.rpm
On Jul 23, 2005, at 12:49 PM, Ware Adams wrote:
Then I don't know what to say about the MyISAM error, though I'd
watch InnoDB pretty carefully as I think MyISAM is pretty robust on
OS X too. We did also see these when a disk is failing, but I
assume you've run disk utility. I guess it
Sol and Peter,
Thanks for your feedback. Both of your suggestions got me going in
the right direction and I was able to solve the problem using
temporary tables and left joins.
Thanks again.
Albert Padley
On Jul 23, 2005, at 11:00 AM, sol beach wrote:
create table count_temp1 select
So I've been poking around my system and I found
/usr/lib/mysql/
/usr/share/mysql/
The mod dates on these are really old. Can I delete these safely?
I'm guessing the are from the Apple install.
These files seem to be in the /usr/local/mysql/ path also. Hmmm... I
looked at my old Mac OS
15 matches
Mail list logo