Monday, August 3, 2015

SQL tutorial - lesson 24 - insert into

If you want to insert a record into table or if you want to copy a record from one table to an another we use insert into

syntax:

INSERT INTO emp (empName, Country) SELECT empno, Country FROM empdata;

No comments:

Post a Comment