Retrieve all columns in a table : Select « Select Clause « SQL / MySQL






Retrieve all columns in a table

  
/*

mysql> select * from student ORDER BY first_name, last_name ASC;
+-----------+------------+-----------+
| StudentID | first_name | last_name |
+-----------+------------+-----------+
|         5 | Anna       | Wolff     |
|         4 | Bruce      | Lee       |
|         3 | Emily      | Scarlett  |
|         2 | Gary       | Burton    |
|         1 | John       | Jones     |
|         7 | Steve      | Alaska    |
|         6 | Vic        | Andrews   |
+-----------+------------+-----------+
7 rows in set (0.02 sec)


*/
Drop table Student;

CREATE TABLE Student (
   StudentID INT NOT NULL PRIMARY KEY,
   first_name      VARCHAR(50) NOT NULL,
   last_name      VARCHAR(50) NOT NULL
   
)TYPE = InnoDB;



INSERT INTO Student (StudentID,first_name, last_name) VALUES (1,'John', 'Jones');
INSERT INTO Student (StudentID,first_name, last_name) VALUES (2,'Gary', 'Burton');
INSERT INTO Student (StudentID,first_name, last_name) VALUES (3,'Emily', 'Scarlett');
INSERT INTO Student (StudentID,first_name, last_name) VALUES (4,'Bruce', 'Lee');
INSERT INTO Student (StudentID,first_name, last_name) VALUES (5,'Anna', 'Wolff');
INSERT INTO Student (StudentID,first_name, last_name) VALUES (6,'Vic', 'Andrews');
INSERT INTO Student (StudentID,first_name, last_name) VALUES (7,'Steve', 'Alaska');
  
select * from student ORDER BY first_name, last_name ASC;


           
         
    
  








Related examples in the same category

1.Define and use variable in select clause
2.Use defined variable in new select clause
3.Select clause with condition
4.Choose specific columns
5.Reference column in select command
6.Performing Mathematics
7.Simple Retrieval:Returning Multiple Columns
8.Simple Retrieval:Returning a Single Column
9.Simple Retrieval: Returning All Columns
10.Performing a Single Row INSERT
11.Using constant string value as comment message for aggregate function
12.Calculation