Using MySQL SELECT statement you can fetch combination of columns and rows from tables or views, known as a result set. This is the one of the most commonly used queries in MySQL to get data from the MySQL database.
You can add or use one or more tables i.e. separated by comma for including various conditions using a WHERE clause. WHERE clause is an optional part of a SELECT statement.
SELECT * FROM user;
Here is few SQL syntax of SELECT command:
SELECT field1, field2,...fieldN FROM table_name1, table_name2...[WHERE Clause] [OFFSET M ][LIMIT N]
Read also: MySQL copy table
You can also use SELECT to retrieve rows computed without any reference to table.
For e.g.
mysql> SELECT 1 + 1; -> 2
Also you are permitted to specify DUAL as a dummy table in situations where there is no tables are referenced:
mysql> SELECT 1 + 1 FROM DUAL; -> 2
There is a good practice to release cursor memory at the end of each SELECT statement in MySQL. Use PHP function mysql_free_result() at the end.
The coronavirus outbreak has drastically changed the way we live our lives. Yes, that's absolutely…
Sales and marketing teams help attract, convert, and retain customers to ensure an organization’s long-term…
Are you an owner of a small business who’s trying to come up with ways…
Introduction When patients bring me their lab reports, the confusion is almost always the same.…
Are you excited about remodeling your house after a long time? Perhaps if you're planning…
The practice of yoga teaches us to be present, patient and mindful of our decisions.…