Simple Retrieval: Returning All Columns : Select « Select Clause « SQL / MySQL

1. SQL / MySQL
2. Select Clause
3. Select

Simple Retrieval: Returning All Columns

  
/*
mysql> CREATE TABLE Student (
    ->    StudentID INT NOT NULL PRIMARY KEY,
    ->    Name      VARCHAR(50) NOT NULL
    -> )TYPE = InnoDB;
Query OK, 0 rows affected, 1 warning (0.08 sec)

mysql> /* Insert data for testing */
mysql> INSERT INTO Student (StudentID,Name) VALUES (1,'Joe Wang');
Query OK, 1 row affected (0.06 sec)

mysql> INSERT INTO Student (StudentID,Name) VALUES (2,'Cory But');
Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO Student (StudentID,Name) VALUES (3,'JJ Harvests');
Query OK, 1 row affected (0.04 sec)

mysql> /* Real command */
mysql> SELECT * FROM Student;
+-----------+-------------+
| StudentID | Name        |
+-----------+-------------+
|         1 | Joe Wang     |
|         2 | Cory But    |
|         3 | JJ Harvests |
+-----------+-------------+
3 rows in set (0.03 sec)


*/

/* Prepare the data */ 
DROP TABLE Student;

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


/* Insert data for testing */ 
INSERT INTO Student (StudentID,Name) VALUES (1,'Joe Wang');
INSERT INTO Student (StudentID,Name) VALUES (2,'Cory But');
INSERT INTO Student (StudentID,Name) VALUES (3,'JJ Harvests');
  
/* Real command */
SELECT * FROM Student;

           
         
    
  

Related examples in the same category