Basic MySQL Query-Introduction to SELECT Statement
In MySQL, SELECT statement is used to pull or retreive any information from MySQL server. This statement include but not limited to get table list, table data or contents and many more. This whole process is usually called by Query.
There is general specific form ot this statement.
SELECT what_to_select
FROM which_table
WHERE conditions_to_satisfy;
what_to_select is what kind of data you want to pull from given table. It can be a specific column or you can use wildcard (*) to select all columns.
which_table is your table name
WHERE clause is optional. You can specify filters after this claus.
And don’t forget to end your statement with semicolon(;).
Example:
SELECT * FROM employee WHERE ID=5;
The command above will return a set of data that contains all columns of the table employee where the column ID is 5.
Its pretty easy right..?
Okay see you next.
