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 Query Statements with GROUP BY in MySQL

⇒⇒MySQL Database Tutorials

2016-10-17, 165👍, 0💬