Config MySQL to ignore ambigous querys

perrohunter

hi !

how can i Config MySQL to ignore ambigous querys ??

Piranha

To my knowledge you can't do it. The reason is that there is nothing like an ambigous query, at least not to the dbms.

Think about it: What is an ambigous query? Can you explain it in english (or your native language) in a clear way that can't be misunderstood? If you can't explain it a computer won't know what it is.

Maybe you are asking about a special query or a way to write queries? In that case please post an example and say why it is ambigous.

perrohunter

An ambigous query would be like this one :

I got TableA with fields ( a,b,c,X) and TableB with fields (h,j,k,X) and I perform the following query:

SELECT a,b,j,k,X FROM TableA LEFT JOIN TableB USING (X) ORDER BY X DESC

This would naturally give me fields a,b,j,k,X with no problem but this causes and ambiguity since X is in both tables and MySQL wouldnt know by which of the sort or which one of them return me, however this is not the correct way to do a JOIN the correct way would be

SELECT a,b,j,k,TableA.X FROM TableA LEFT JOIN TableB USING (X) ORDER BY TableA.X DESC

In this example I'm specifying the correct way which X i need and by which X i want to sort the results

I Got alot of querys like the first one on my system which resides on my webhost , but as soon as I run the same system on my local machine I start getting alot of errors , I'd love to correct all my querys , but I need a quick solution meanwhile , so I can run the system on a backup server

Does anyone got an idea ?

Piranha

I didn't think the first query would work on any dbms, apparently I am wrong. I have no solution, byt a few guesses to what could cause the difference:

Different databases. For example you run MySQL and the live site uses Oracle.
Different versions of databases. For example you use MySQL 5.x and the host uses 3.x.

But as I said above I don't know. Hopefully someone else will be able to give an answer.

perrohunter

My host uses MySQL 5.0.46 and Im using MySQL 5.0.41

I was thinking it was some sort of configuration of mysql but I've been googling it and I just can't find it