SQL -- Inserting Data into Table

Insert statement is used to insert or add a row of data into the table.

insert into myemployees_RDP0680

            (firstname, lastname, title, age, salary)

            values ('Mike', 'Jones', 'CEO', 55, 320000)

insert into myemployees_RDP0680

            (firstname, lastname, title, age, salary)

            values ('Sean', 'Mason', 'VP', 50, 200000)

insert into myemployees_RDP0680

            (firstname, lastname, title, age, salary)

            values ('Arun', 'Shah', 'Progammer', 40, 120000)

Select statement is used to show data.

select * from myemployees_RDP0680