Basic details while learning MY SQL:

 SQL -  In database the field name should be in lowercase. Every SQL statement should end with semicolon ;

Shortcut Ctrl+G is Go to line

Ctrl+ENTER is to run a query 

STEPS FOR WRITING MYSQL:

1. To write a query first we need to select the database.

2. Then we need to select the table.

3.Once we select both then we press "Ctrl+space", then it will show possible fields in the current table.

4. There are only two wildcards in MYSQL. They are,

        i) %

        ii)_