Re: Works in sqlite.

Hi 

Cloud SQL uses MySQL as the database engine and there are some syntax differences with SQLite.

Have a look at http://dev.mysql.com/doc/refman/5.5/en/select.html for more details on the correct syntax for MySQL SELECTs

j

On Tue, May 15, 2012 at 7:46 AM, JK Winkler <jsmith27182@gmail.com> wrote:

This SQL works fine in sqlite but not in the Cloud SQL Console.

Select  x, a3.a,  a1.a, a2.a
From a_s a1, a_s a2, x_s, a_s a3
Where (a3.a * x*x) + (a1.a * x) + a2.a = 32777

I get the following error:

Error 0: Unable to execute statement

There are only 255 rows and one column in each table.

--
Joe Faith | Product Manager | Google Cloud