Q:

What is FULL keyword for in MySQL?

MySQL isn't supporting FULL OUTER JOIN. 
Then, what is the keyword FULL in MySQL is for? 
I don't see FULL in this list. 
However, I'm not getting a syntax error on FULL when I put together a query 
involving FULL JOIN in MySQL. 

A:

You haven't posted your query, so of course it's impossible to answer your question definitively; but most likely, full is being interpreted as a table alias. For example:
SELECT full.c1,
       t2.c2
  FROM t1 full
  JOIN t2
    ON full.id = t2.id
;

where full is an alternative name for t1 for use inside the query. (This is useful when the table appears multiple times in the query and you need to distinguish the uses, or when you have a long table-name that becomes a distraction when you prefix all the columns with their table-names, or whatnot.)

