Re: Syntax Problem

2006-12-08 Thread JugLugs
Field was wrongly named - Cheers! -- View this message in context: http://www.nabble.com/Syntax-Problem-tf2779708.html#a7756233 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

Re: Syntax Problem

2006-12-08 Thread Martijn Tonies
> I have a query running within a project from a Windows machine retrieving > data from a Linux Source the query works perfectly. If i upload the exact > same project to the Linux machine and run it the query doesnt work ??!!?? > > the query string is ... > > SELECT DISTINCT ID, BatchID FROM Conta

Re: Syntax problem: mysql 3.23 vs 4.13

2005-03-30 Thread Gleb Paharenko
Hello. Select syntax is correct on my 4.1.10a MySQL instance. EXPLAIN is telling me 'Impossible WHERE' until I put values in the tables so the query could produce at least several rows. After that everything was OK. Graham Anderson <[EMAIL PROTECTED]> wrote: > this sql works on mys

re: syntax problem with replicate-rewrite-db

2002-11-20 Thread Victoria Reznichenko
David, Tuesday, November 19, 2002, 5:20:23 PM, you wrote: DN> (sorry if this is a duplicate -- I don't think the original made it) DN> Running mysql 3.23.53-max binary on a RedHat 7.2 based server. Replication DN> is working fine, but I'm running into errors with the replicate-rewrite-db DN> dir

Re: syntax problem

2001-07-22 Thread Sara
sage - From: "Werner Stuerenburg" <[EMAIL PROTECTED]> To: "Sara" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, July 22, 2001 7:11 PM Subject: Re: syntax problem > > I rather thought that this was the whole purpose of this mailing list? > &g

Re: syntax problem

2001-07-22 Thread Werner Stuerenburg
> I rather thought that this was the whole purpose of this mailing list? You are right both in your inquiry and in your reply to Sinisa. It is not his usual way, though, I was astonished myself. I think most is ok. Try select handicap_results.date, handicap_results.victor, handic

Re: syntax problem

2001-07-22 Thread Sara
after all trying to learn mysql and am a beginner. Regards Sara - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, July 22, 2001 11:22 AM Subject: Re: syntax problem > Sar

Re: syntax problem

2001-07-22 Thread Sinisa Milivojevic
Sara writes: > Hi > > I have compiled a report using Mascon only to find I can't export it to any other >software I have! Great report but not much good to me as it is :-( > > (I'm not well versed in php yet, otherwise this might be an issue) > > However, I did get the sql query script and th

Re: Syntax problem...

2001-04-10 Thread Peter Pentchev
On Tue, Apr 10, 2001 at 12:48:26PM +0200, Guerin Damien wrote: > Hi, > > How use CHECK constraint in a CREATE TABLE declaration ?? > The language used is MySQL > Indeed, i try many attempt but no success... Somebody could help me ?? > > I try to do that : > > create table Picsou ( > nam