MySQL Select

SQL SELECT is the most frequently used SQL command. The SQL SELECT command is used to retrieve data from one or more database tables.
The SQL statement below shows a simple usage of the SQL SELECT command:
1
SELECT FirstName, LastName, DateOfBirth FROM Users
You can use the following SQL query to make an exact copy of the data in the Users table:
1
SELECT * INTO UsersBackup FROM Users
There is a special syntax that can be used with the SELECT command, if you want to retrieve all columns from a table. To do that, replace the list of columns with the * symbol:
1
SELECT * FROM Users