How to become a expert person in MYSQL database select statment?
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$2 Answers
SQL WHERE Syntax
SELECT column_name(s)
FROM table_name
WHERE column_name operator value
with "AND, OR" operators
SELECT * FROM Persons
WHERE FirstName='Tove'
AND LastName='Svendson'
With "order by"
SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC|DESC
You can learn more about select from this tutorial:
http://www.w3schools.com/sql/sql_select.asp
You can also find advanced select statements from:
http://www.smart-soft.co.uk/Oracle/advanced-sql-tutorial.htm
http://sqlcourse2.com/select2.html
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
It could be argued that if one is an expert with the select statement that they are an expert in mySQL itself.
To start you down your path, I would purchase this book:
http://oreilly.com/catalog/9780596514334/
I would go to this conference:
http://www.mysqlconf.com/mysql2009
Above all else, I would work with sample data from a variety of sources. This book has a variety of problems and activities to help you gain hands on experience with data and various select statements:
http://oreilly.com/catalog/9780596006303/
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
