RE: MYSQL on a Cobalt RaQ4

Hi Denis, According to its datasheet, the RaQ4 is a 450MHz Intel compatible machine running Linux 2.2 so I can't see any problems installing and running MySQL on it. Regards, Chris > -Original Message- > From: Denis Croombs [mailto:[EMAIL PROTECTED]] > Sent: 27 March 2002 14:30 > To: M

RE: SQL

Hi Miguel, As far as I know (I'm no expert), this can't be done in a single MySQL query. The following link shows how you can do it using a temporary table: http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#exam ple-Maximum-column-group-row Alternatively, if you are using

conditional delete query

Hi All, I'm having trouble forming a delete query that removes rows from a table based on a condition that requires joining 3 tables (including the table to delete from). The SELECT query that identifies the rows to delete is: SELECT folder_items.folder_id, folder_items.item_id FROM folders, fo

RE: Offtopic JDBC

Hi Othmar, I'm sure its probably a typo in your message, but isn't the default port 3306 and not 3360? Also, isn't there a : after mysql? e.g. jdbc:mysql://localhost:3306/ If its not this then let me know and I'll try and suggest a solution. Best Regards, Chris -Original Message- F

select rows where count of column is zero

Hi All, I'm trying to select a number of columns from 2 tables using an inner join. One of the columns I'm selecting is a count and when the count is zero it doesn't return that row. I'd like to return all rows, even if the count of one of the columns is zero. Can somebody show me how to fix my

ENUMs as user defined types?

Hi all, Is it possible to define an enumeration as a new MySQL data type and then define columns using the user defined type? I've heard that you can produce aliases for types but I can't find anything in the manual about doing this for ENUMs. Thanks for your help, Chris --