|
/*
mysql> select * from Student;
+-----------+------------+-----------+
| StudentID | first_name | last_name |
+-----------+------------+-----------+
| 1 | John | Jones |
| 2 | Gary | Burton |
| 3 | Emily | Scarlett |
| 4 | Bruce | Lee |
| 5 | Anna | Wolff |
| 6 | Vic | Andrews |
| 7 | Steve | Alaska |
+-----------+------------+-----------+
7 rows in set (0.01 sec)
mysql> select * from Student WHERE StudentID != 8 ORDER BY studentID;
+-----------+------------+-----------+
| StudentID | first_name | last_name |
+-----------+------------+-----------+
| 1 | John | Jones |
| 2 | Gary | Burton |
| 3 | Emily | Scarlett |
| 4 | Bruce | Lee |
| 5 | Anna | Wolff |
| 6 | Vic | Andrews |
| 7 | Steve | Alaska |
+-----------+------------+-----------+
7 rows in set (0.00 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 (4,'Bruce', 'Lee');
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 (7,'Steve', 'Alaska');
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 (3,'Emily', 'Scarlett');
select * from Student;
select * from Student WHERE StudentID != 8 ORDER BY studentID;
|
