HIT1402 Ref Guide. SingleTable INSERT data

From SwinBrain

The following statements each insert a single row of data into the Employee table

INSERT INTO Employee (EmpNo, FirstName, Surname, Salary, Gender)
VALUES (1001, 'Sue', 'Jones', 73000, 'F');

INSERT INTO Employee (EmpNo, FirstName, Surname, Salary, Gender)
VALUES (1005, 'Fred', 'Smith', 65000, 'M');

INSERT INTO Employee (EmpNo, FirstName, Surname, Salary, Gender)
VALUES (1013, 'Sara', 'Brown', 50000, 'F');


Navigation:
HIT1402