SQL tip 1:
- Instead of Full Outer Join, you can use Union All.
- Difference is, Full Outer Join provides results side by side.
- Union All provides result s one by one.
- Note: MYSQL does not support Full Join.
SQL tip 2:
- To get column name of a table use following sql query
- Select column_name from information_schema.columns
- Where table_name = 'student'
- Here 'student' is name of your table. It must be single quoted
- If you want to complete information about table then use following queries.
- Select * from information_schema.columns
- Where table_name = 'student'
SQL tip 3:
- Avoid Order By clause unless you need result in ascending or descending order.
- It will be slower your query execution.