Selecting Columns in a Query in MySQL

Q

How To Select Some Columns from a Table in MySQL?

✍: FYIcenter.com

A

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

SELECT Query Statements with GROUP BY in MySQL

⇑⇑ MySQL Database Tutorials

2017-11-05, 1235🔥, 0💬