MySQL is the most popular Open Source SQL database management system. It is developed, distributed, and supported by Oracle Corporation and used by big companies like, Google, Facebook, Youtube, Flickr and Wikipedia. It is named after co-founder Michael Widenius's daughter, My.
The data in MySQL is stored in tables. A table is a collection of related data, and it consists of columns and rows, this makes it us useful when storing information categorically.
Useful Select PhrasesComments (0)
To get all information from a users table
SELECT * FROM users
To get all information from a users table where user_id is 1:
SELECT * FROM users WHERE user_id = 1
To get all the information from a users table and use the ORDER BY feature (ASC/DESC):
SELECT * FROM users ORDER BY user_id DESC
To get all the information from a users table and limit the query to 10:
SELECT * FROM users LIMIT 10