|
/*
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 Yin');
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 Yin |
| 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 Yin');
INSERT INTO Student (StudentID,Name) VALUES (2,'Cory But');
INSERT INTO Student (StudentID,Name) VALUES (3,'JJ Harvests');
/* Real command */
SELECT * FROM Student;
|
