Collections:
Selecting Columns in a Query in MySQL
How To Select Some Columns from a Table in MySQL?
✍: FYIcenter.com
If you want explicitly tell the query to return some columns, you can specify the column names in the SELECT clause. The following select statement returns only two columns, "id" and "url" from the table "fyi_links":
mysql> SELECT id, url FROM fyi_links; +-----+-------------------+ | id | url | +-----+-------------------+ | 101 | dev.fyicenter.com | | 102 | dba.fyicenter.com | | 103 | sqa.fyicenter.com | +-----+-------------------+ 3 rows in set (0.00 sec)
⇒ Select Rows with WHERE Clause in MySQL
⇐ Selecting All Columns of All Rows in MySQL
2017-11-05, 1321🔥, 0💬
Popular Posts:
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...