Performing a Single Row INSERT : Select : Select Clause SQL / MySQL

SQL / MySQL » Select Clause » Select »

Performing a Single Row INSERT



/*
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;