MySQL SELECT Statement

Select statement is used to retrieve table data; you must provide the table name. The select key word in MySQL is case insensitive, you can use SELECT or Select. It’s the same. We use the SELECT Statement to query the data information.

SIMPLE SELECT STATEMENT

>>SELECT * FROM profile;

DISPLAY: