Problem with SQL query

Question

0.00/5 (No votes)

See more:

Hello! Can you tell me what is error there is in my query SQL?
I checked common number of each table's fields and check syntax, but i dont understand, how fix error.

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as ssss FROM typeorder UNION SELECT "estate", idTYPE, TYPENAME_AZ, T' at line 1

SQL

SELECT "type", idTYPEORDER AS "id", TYPEORDERNAME_AZ AS "name", TYPEORDERNAME_AZ as name_d, TYPEORDERNAME as name_ru, DEFAULT as ssss FROM typeorder
UNION
SELECT "estate", idTYPE, TYPENAME_AZ, TYPENAME_AZ,TYPENAME,DEFAULT FROM type_estate
UNION
SELECT "flats", idAPARTAMENT_FLATS, APARTAMENT_FLATSNAME_AZ, APARTAMENT_FLATSNAME_AZ, APARTAMENT_FLATSNAME, DEFAULT FROM apartament_flats
UNION
SELECT "currency", idCURRENCY, CURRENCYNAME_AZ, CURRENCYNAME_AZ, CURRENCYNAME, DEFAULT FROM currency
UNION
SELECT "country", idCOUNTRY, COUNTRYNAME_AZ, COUNTRYNAME_AZ, COUNTRYNAME , DEFAULTFROM country
UNION
SELECT "region", idREGION, REGIONNAME_AZ, REGIONNAME_AZ, REGIONNAME, DEFAULT FROM region
UNION
SELECT "city", idCITY, CITYNAME_AZ, CITYNAME_AZ, CITYNAME, DEFAULT FROM city
UNION
SELECT "village", idVILLAGE, VILLAGENAME_AZ,VILLAGENAME_AZ, VILLAGENAME, DEFAULT FROM village
UNION
SELECT "bedroom", idBEDROOM, BEDROOMNAME_AZ, BEDROOMNAME_AZ, BEDROOMNAME, DEFAULT FROM bedroom
UNION
SELECT "position", idPOSITION, POSITIONNAME_AZ, POSITIONNAME_AZ, POSITIONNAME, DEFAULT FROM position
UNION
SELECT "toilet", idTOILET, TOILETNAME_AZ, TOILETNAME_AZ, TOILETNAME, DEFAULT FROM toilet
UNION
SELECT "view", idVIEW, VIEWNAME_AZ, VIEWNAME_AZ, VIEWNAME, DEFAULT FROM view
UNION
SELECT "flat", idAPARTAMENT_FLAT, APARTAMENT_FLATNAME_AZ, APARTAMENT_FLATNAME_AZ, APARTAMENT_FLATNAME, DEFAULT FROM apartament_flat
UNION
SELECT "repair", idREPAIRTYPE, REPAIRTYPENAME_AZ, REPAIRTYPENAME_AZ, REPAIRTYPENAME, DEFAULT FROM repairtype
UNION
SELECT "project", idPROJECT, PROJECTNAME_AZ, PROJECTNAME_AZ, PROJECTNAME, DEFAULT FROM project
UNION
SELECT "rooms", idApartamentrooms, APARTAMENTROOMS_AZ, APARTAMENTROOMS_AZ, APARTAMENTROOMS, DEFAULT FROM apartament_rooms
UNION
SELECT "position_type", idPOSITION, POSITIONNAME_AZ, POSITIONNAME_AZ, POSITIONNAME, DEFAULT FROM position_type
UNION
SELECT "comfort", idCOMFORT, COMFORTNAME_AZ, COMFORTNAME_AZ, COMFORTNAME, DEFAULT FROM comfort
UNION
SELECT "metro", idMETRO, METRONAME_AZ, METRONAME_AZ, METRONAME, DEFAULT FROM metro ORDER BY name

Posted 20-Jun-13 5:52am

Jardin1

Updated 21-Jun-13 9:58am

Maciej Los

v2

Add a Solution

Comments

Jardin1 20-Jun-13 11:55am

And what is case for optimize this query? Instead _AZ possibility inserting "_RU", "_EN"

Mike Meinz 20-Jun-13 14:30pm

Do you think the problem might be that DEFAULT is a reserved word and you are using it as the name of one of the columns in your database tables?

The rules for using UNION are:
(1) The number and the order of the columns must be the same in all queries,
(2) The data types must be compatible.

Make sure all of your SELECTs follow the rules.

Also, you spelled apartment wrong.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2013-06-20T14:18:00

First ... as Mike Meinz pointed out DEFAULT is a key word. Change the name of the columns on your database or (this is SQL Server but I think it works with MySQL) surround the column name with square brackets ... i.e. [DEFAULT]

Secondly... you are using UNION to join together queries containing very different data items ... flats & estates might go together, but putting toilets & rooms in there too????? If you want to "optimise" this query you will need to give hints of what you're actually trying to do with the results of this query ... at the moment it appears to be pointless.

Thirdly, learn that whitespace is your best friend, especially when you use tools that say things like "Error on line 6 near 'as ssss" ... so much easier to pinpoint the problem than "Error on line 1" (seriously, your DBMS really wants to say "somewhere in this very long line of text that no-one can read")

At the very least put some carriage returns around each UNION - I personally prefer having each clause (SELECT, FROM, UNION, ORDER BY etc) on a separate line - it's served me very well over the years to get straight to the problem