Re: Totals Across Multiple Records

2005-07-23 Thread Peter Brawley
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

Re: 4.1.13 OS X MAJOR I/O Degredation

2005-07-23 Thread Ware Adams
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

storing php pages with sql queries in a mysql database

2005-07-23 Thread Gregory Machin
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

Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
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

libmySQL.so location

2005-07-23 Thread Tim Johnson
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

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Ware Adams
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

Re: libmySQL.so location

2005-07-23 Thread sol beach
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

Re: storing php pages with sql queries in a mysql database

2005-07-23 Thread Ludwig Pummer
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

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
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.

Re: libmySQL.so location

2005-07-23 Thread Tim Johnson
* 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]

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Ware Adams
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

Re: libmySQL.so location

2005-07-23 Thread Tim Johnson
* 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

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
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

Re: Totals Across Multiple Records

2005-07-23 Thread Albert Padley
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

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
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