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, 1250🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...