Subquery Problem With mysql-4.0 (Works with mysql-5.0)

I face one problem with mysql4.0 I've two tables, one called company and the other called favorites. The relation between those two tables is CO_ID on the company table and MASTER_CO_ID on the favorites table. When I run the following query it works fine on mysql-5.0 but it give error with

Re: Subquery Problem With mysql-4.0 (Works with mysql-5.0)

2006/6/5, MySQL Nexeia [EMAIL PROTECTED]: I face one problem with mysql4.0 I've two tables, one called company and the other called favorites. The relation between those two tables is CO_ID on the company table and MASTER_CO_ID on the favorites table. When I run the following query it works

synopsis of the problem (one line)

Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

sad asd as

dsa dsad

hierarchical sql

Hi everyone, Someone know if mysql 5 has hierarchical sql? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: hierarchical sql

João Cândido de Souza Neto wrote: Hi everyone, Someone know if mysql 5 has hierarchical sql? http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html PB Thanks. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database:

Moving database files to larger partition?

I'm currently setting up MySQL 4.1.2 on RHEL 4.1 and I have found the /etc/my.cnf file. I'm trying to find out if I change the basedir from: Basedir=/var/lib To Basedir=/other/path Will that move the actual data files that have all my databases? Do I need to move any of the things that are

Re: Broken Mac pref panel

On Sunday 04 June 2006 20:38, Marcus Bointon scribble on about: On 4 Jun 2006, at 23:25, Marcus Bointon wrote: I'm having trouble with the prefpane in OS X It seems I'm not alone - there are several reports of this in the MySQL bug tracker. Looks like a bug in the prefpane:

Re: Moving database files to larger partition?

On 6/5/06, Jay Paulson [EMAIL PROTECTED] wrote: I'm currently setting up MySQL 4.1.2 on RHEL 4.1 and I have found the /etc/my.cnf file. I'm trying to find out if I change the basedir from: Basedir=/var/lib To Basedir=/other/path Will that move the actual data files that have all my

Re: procedure analyse() returns bad type?

Hi Gaspar, The following command returns recommended type FLOAT(3,6) for a double(10,6) column: mysql CAT -t -u catadmin -p -e \ select * from temp procedure analyse(16,8192) temp.log Optimal_fieldtype = FLOAT(3,6) NOT NULL. The trouble is that FLOAT(3,6) does not make sense, with

yum repos for mysql 5.[1] for FC5

Hi all, hate to ask a question that probably has a really obvious answer, but does anyone know of the existence of a mysql 5.1 yum repo that I can point my FC5 box at? -- brendan bouffler Architect, HPC New Technology APJ ESS Competency Lab x: Sydney, Australia, v: +61 404 097 837 mtb: 2003

UPDATE from one server to another

I am working on an application where data will be collected on laptops and then uploaded to a central database once the laptop is able to connect to the network after being in the field. I was initially thinking of using MS Access as a front end with linked tables through MySQL ODBC. I am

Security fix for 4.0.27?

Anyone know if 4.0.27 will be fixed for the mysql_real_escape issue? (http://lists.mysql.com/announce/364) 4.1 and 5 have been already, kinda wondering why 4.0 hasn't. Thanks. [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the