Hi,
I converted my access database in MySQL and the conversion is valid because i can do some basic requests. But I have a request that i can't execute on MySQL, i lost the server connection and the server go down when i execute it. The request is correct (i think!) because i can execute it on the access database with any problem.
Someone could be help me, please. I don't know if MySQL have limited size on the SELECT request, or other thing.
If someone have had the same problem...
The request is :
SELECT DISTINCT C.LIB_CONTRAINTE,C.CODE_CONTRAINTE
FROM T_PROBLEME AS Po, T_CONTRAINTE AS C,
T_LNK_PROBLCONTR AS bC, T_LNK_PROBREFERENCE AS PbR,
T_REFERENCE AS R,
T_NATURE AS N,T_ALPHA AS A
WHERE A.LIB_ALPHA LIKE 'JD' AND A.ID_ALPHA=Po.ID_ALPHA
AND C.ID_CONTRAINTE=PbC.ID_CONTRAINTE
AND Po.ID_PROBLEME=PbC.ID_PROBLEME
AND Po.ID_PROBLEME=PbR.ID_PROBLEME
AND PbR.ID_REFERENCE=R.ID_REFERENCE
AND R.ID_NATURE=N.ID_NATURE
ORDER BY C.LIB_CONTRAINTE,C.CODE_CONTRAINTE;
Thanks.
Phil.
I converted my access database in MySQL and the conversion is valid because i can do some basic requests. But I have a request that i can't execute on MySQL, i lost the server connection and the server go down when i execute it. The request is correct (i think!) because i can execute it on the access database with any problem.
Someone could be help me, please. I don't know if MySQL have limited size on the SELECT request, or other thing.
If someone have had the same problem...
The request is :
SELECT DISTINCT C.LIB_CONTRAINTE,C.CODE_CONTRAINTE
FROM T_PROBLEME AS Po, T_CONTRAINTE AS C,
T_LNK_PROBLCONTR AS bC, T_LNK_PROBREFERENCE AS PbR,
T_REFERENCE AS R,
T_NATURE AS N,T_ALPHA AS A
WHERE A.LIB_ALPHA LIKE 'JD' AND A.ID_ALPHA=Po.ID_ALPHA
AND C.ID_CONTRAINTE=PbC.ID_CONTRAINTE
AND Po.ID_PROBLEME=PbC.ID_PROBLEME
AND Po.ID_PROBLEME=PbR.ID_PROBLEME
AND PbR.ID_REFERENCE=R.ID_REFERENCE
AND R.ID_NATURE=N.ID_NATURE
ORDER BY C.LIB_CONTRAINTE,C.CODE_CONTRAINTE;
Thanks.
Phil.