Problem solution
Soluzioni ai vostri errori e problemi

Find here the solution to your problem and error: search



Chi è online

We have 5 guests online

Source SQL Error using after mysql update
Error using after mysql update Print E-mail
Source - SQL
Saturday, 13 March 2010 18:48

It may happen that after an updated version of mysql there are several errors. One of them is when there is a JOIN in your query associated with the command USING.

To resolve the error just replace the obsolete part of query:
LEFT JOIN table1 USING (fieldId)
with the following SQL code:
LEFT JOIN table1 AS aliasName on (aliasName.fieldId = table2.fieldId)

 


bottom
top

bottom

© 2009 Problem-Error.com - Disclaimer