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 <grah...@siren.cc> wrote:
this sql works on mysql version 3.23.58...my remote server
SELECT c.City, r.Region, co.Country
FROM subnets s, cities c, regions r, countries co
WHERE c.CityId = s.CityId
AND c.RegionID = r.RegionID
AND c.CountryID = co.CountryId
AND s.SubNetAddress = '24.24.172'
LIMIT 0 , 30
but the same syntax fails on mysql version 4.1.3-beta ...my local
computer
When I EXPLAIN the sql, I get the error:
Impossible WHERE noticed after reading const table...
anyone know what this could be ?
2 messages in com.mysql.lists.mysqlRe: Syntax problem: mysql 3.23 vs 4.13
