Mega Code Archive

 

Categories / MySQL / Select Clause

 

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;