Beware of the case in MySQL Query

LINUX is case sensitive…
Assuming there is a table named category on your database, compare the following 2 queries:

SELECT category_id, CONCAT(main_cat_name,' ::: ',category_name) FROM category ORDER BY 2
SELECT category_id, CONCAT(main_cat_name,' ::: ',category_name) FROM CATEGORY ORDER BY 2

Both queries will work on MySQL server on WINDOWS, but only the first one works on LINUX. The second query will rise error ‘Table CATEGORY doest exist’