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, 1236🔥, 0💬
Popular Posts:
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...