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.