Edit Article
How to Retrieve Data from Mysql
Edited by Sharimo1, Samnav, Maluniu, Harri and 6 others
The basic SQL query for retrieving data from a MySQL database is the SELECT command.
Ad
EditSteps
-
1Type:- SELECT
- <columnname1>, <columnname2>, ... <columnnamen>'
- FROM <tablename> ;
AdAd - SELECT
EditTips
- Use "*" instead of column names to get all columns.
- You can use a function (e.g. AVG, COUNT, MAX, MIN, etc.) instead of column names.
- Additional parameters you can append:
- ORDER BY <columnname> - Sort resulting data by the values in the given column in ascending order.
- ORDER BY DESC <columnname> - Sort data by values in the given column in descending order.
- GROUP BY <columnname> - group the information by the values in the given column.
- Lots more options exist. See the documentation at mysql.com
- Import/Export data by using Navicat for MySQL: http://www.navicat.com
Ad
