Contents

Description

SELECT is used to retrieve rows selected from one or more tables, and can include UNION statements and subqueries.

Each select_expr expression indicates a column or data that you want to retrieve. You must have at least one select expression. See Select Expressions below.

The FROM clause indicates the table or tables from which to retrieve rows. Use either a single table name or a JOIN expression. See JOIN for details. If no table is involved, FROM DUAL can be specified.

Each table can also be specified as db_name.tabl_name. Each column can also be specified as tbl_name.col_name or even db_name.tbl_name.col_name. This allows to write queries which involve multiple databases. See Identifier Qualifiers for syntax details.

The WHERE clause, if given, indicates the condition or conditions that rows must satisfy to be selected. where_condition is an expression that evaluates to true for each row to be selected. The statement selects all rows if there is no WHERE clause.

* to select all columns from all tables in the Marc Swimwear Carmen Piece Valvo Swimsuit One Boutique FROM clause.

tbl_name.* to select all columns from just the table tbl_name.

When specifying a column, you can either use just the column name or qualify the column name with the name of the table using tbl_name.col_name. The qualified form is useful if you are joining multiple tables in the FROM clause. If you do not qualify the column names when selecting from multiple tables, MariaDB will try to find the column in each table. It is an error if that column name exists in multiple tables.

You can quote column names using backticks. If you are qualifying column names with table names, quote each part separately as `tbl_name`.`col_name`.

If you use any grouping functions in any of the select expressions, all rows in your results will be implicitly grouped, as if you had used GROUP BY NULL.

Swimsuit Marc Carmen Boutique Piece Swimwear One Valvo DISTINCT

A query may produce some identical rows. By default, all rows are retrieved, even when their values are the same. To explicitly specify that you want to retrieve identical rows, use the ALL option. If you want duplicates to be removed from the resultset, use the DISTINCT option. DISTINCTROW is a synonym for DISTINCT. See also COUNT DISTINCT and SELECT UNIQUE in Oracle mode.

INTO

The INTO clause is used to specify that the query results should be written to a file or variable.

Comments

Is there any inverse SELECT in MariaDB for selecting all columns but few specified? I found in practice very useful syntax like:

SELECT * EXCEPT (col1, col2) FROM ...

This would select all columns except for those declared within the EXCEPT keyword. This is specially useful for tables with many columns. MySQL does not support anything similar, currently neither does MariaDB as far as I know.

It seems equally as bad as select *. There's a number of reasons why select * are bad - http://www.parseerror.com/blog/select-*-is-evil . There are exceptions to this rule (like every rule) but it in generally using select * is a common way to incur a software maintenance debt. It also can force the db to retrieve more data than needed, and in doing, so miss out on query optimisations to get your data quicker (if you don't actually need all columns).