Problem solution
Soluzioni ai vostri errori

Find here the solution to your problem: search



Chi è online

We have 11 guests online

Home 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 - Best List Top Charts Hits - Disclaimer