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.
For any types of queries, you can contact us on info[at]namasteui.com.
Introduction: As the chill of winter settles in or a bout of cold weather strikes,…
Nestled along the glittering waterfront of the City of Gold, Dubai Marina beckons to discerning…
When was the last time you heard that a clone app like Gojek could efficiently…
The e-commerce market is growing and evolving at a rapid pace. More and more people…
IplWin stands as a reliable and enthralling platform for Indian punters, offering a captivating blend…
Introduction In today's online age, consumers are constantly bombarded with information. They crave valuable content…