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;
syntax:
INSERT INTO emp (empName, Country) SELECT empno, Country FROM empdata;
No comments:
Post a Comment