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

1. SQL / MySQL
2. Select Clause
3. 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;
           
         
    
  

Related examples in the same category