more SQL tutorial

Let us build a database  'test' with table  'person' inside it, having column  name, age, gender. see how to do this

Insert a line into table:

INSERT INTO person (name, gender) VALUES ('omphu', 'female')

This will add a new line or data into the table  'person' on column  name, gender with value omphu, female respectively and will leave the value of age blank.

Select line using WHERE:

SELECT * FROM person WHERE gender='female'

Select specific column:

SELECT name FROM person WHERE gender='male'

This will output the value of column name where gender is female.

Specify more argument to refine search:

SELECT name, age FROM person WHERE age='21' AND gender='male'

Will output result if this two condition are true,  age & gender.

SELECT name, age FROM person where age='21' OR gender='female'

This will output result if one of the two condition is true,  age & gender.

Limit output to 5 result:

SELECT * FROM person LIMIT 5

Sort result by Ascending/Descending order:

SELECT * FROM person ORDER BY name ASC

SELECT * FROM person ORDER BY name DESC

Query name which contain the letter  a.

SELECT * FROM person WHERE name LIKE '%a%'

Query only unique name:

SELECT DISTINCT(name) FROM person

This query is useful when we have many duplicate data of the same value.

Count total line in the table:

SELECT COUNT(name) FROM person

Disclaimer:
Tutorial above are only for educational purposes. The author will not take any liability for any damage cause by use or improper use of tutorial above.

---