Sub Queries in MYSQL and JOINS

2004-07-08 Thread James Raff
I have MYSQL 3.23.32 on a Cobalt 550 platform. I see from the FAQ's that sub queries will not work on MYSQL < 4.1. Is there a way to use JOIN statements instead or do these fail too. eg: SELECT some_ID from someTable NOT IN (Select some_ID from ANOTHERTABLE) Or do I have to redesign my website!

Upgrading MySql on RaQ4i

2001-02-23 Thread James Raff
Can anybody give a newbie some clear instructions on how to upgrade a Cobalt RaQ4i server running 3.22.32-1 to the latest 3.23.33 version. The Cobalt MySQL server installation originally used a .pkg file but cobalt have indicated a new .pkg install will screw up - its apparently not that simple

Cobalt .pkg scripting

2001-01-23 Thread James Raff
and then we will put it on the net . An indication of costs would be helpful. James Raff Director www.masterbuildersonline.com

Installing Mysql on a cobalt raq4

2001-01-22 Thread James Raff
If you want to install MySQL on a RaQ4 go to the Cobalt web site at http://pkg.nl.cobalt.com. You will find a special .pkg file the will install in just a few minutes. The big "BUT!" - you have to clear out ALL traces of any previous MySQL installation. We got our hosting operation to reload th