Here, In this article we are going to explain some MySQL query syntax.

Example 1: Select * FROM Table_Name

Example 2: Select name,email,mobile FROM Table_Name

In example third we are going to explain MySQL conditional query.

Example 3:

Select * FROM Table_Name WHERE name=’JOY’
Select * FROM Table_Name WHERE name=’JOY’ AND Mobile=’9999558555′
Select * FROM Table_Name WHERE name=’JOY’ OR name=’Tom’
Select * FROM Table_Name WHERE (name=’JOY’ OR name=’Tom’) AND (mobile=’9999558555′ OR mobile=’9999000000′)
Select * FROM Table_Name WHERE (name=’JOY’ AND email=’tom@gmail.com’) OR(mobile=’9999558555′ AND email=’tom@gmail.com’)

In example fourth we are going to explain MySQL Join.

Example 4:

Select * FROM Table_Name INNER JOIN Table_name2 ON Table_Name.id=Table_Name2.id
Select * FROM Table_Name LEFT JOIN Table_name2 ON Table_Name.id=Table_Name2.id
Select * FROM Table_Name RIGHT JOIN Table_name2 ON Table_Name.id=Table_Name2.id

If you want learn more about MySQL next article you search on my website.