|
/*
mysql> Select * from Professor;
+-------------+---------------+
| ProfessorID | Name |
+-------------+---------------+
| 0 | Snail at work |
+-------------+---------------+
1 row in set (0.00 sec)
*/
/* Create the table */
Drop TABLE Professor;
CREATE TABLE Professor (
ProfessorID INT NOT NULL PRIMARY KEY,
Name VARCHAR(50) NOT NULL)
TYPE = InnoDB;
/* Real command */
INSERT INTO Professor (ProfessorID, Name)
VALUES (0, 'Snail at work');
/* Check the result */
Select * from Professor;
|