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=’[email protected]’) OR(mobile=’9999558555′ AND email=’[email protected]’)

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.

News Reporter
IT Software and web development, Core PHP, JavaScript, JQuery, HTML, CSS, CakePHP, Angularjs, Codeigniter etc.

Leave a Reply

Your email address will not be published. Required fields are marked *

error: