INSERT INTO Student(ROLL_NO,NAME,Age) SELECT ROLL_NO, NAME, Age FROM LateralStudent ROLL_NO NAME ADDRESS PHONE Age 1 Ram Delhi XXXXXXXXXX 18 2 RAMESH GURGAON XXXXXXXXXX 18 3 SUJIT ROHTAK XXXXXXXXXX 20 4 SURESH Delhi XXXXXXXXXX 18 3 SUJIT ROHTAK XXXXXXXXXX 20 2 RAMESH GURGAON XXXXXXXXXX 18 7 SOUVIK DUMDUM XXXXXXXXXX 18 8 NIRAJ NOIDA XXXXXXXXXX 19 9 SOMESH ROHTAK XXXXXXXXXX 20 This query will insert all the data of the table LateralStudent in the table Student. INSERT INTO Student SELECT * FROM LateralStudent

Method 1(Inserting all rows and columns):.

Table2: LateralStudent ROLL_NO NAME ADDRESS PHONE Age 7 SOUVIK DUMDUM XXXXXXXXXX 18 8 NIRAJ NOIDA XXXXXXXXXX 19 9 SOMESH ROHTAK XXXXXXXXXX 20 INSERT INTO table1 SELECT * FROM table2 WHERE condition Ĭondition: condition to select specific rows. We have to provide appropriate condition in the WHERE clause to select specific rows.

Copying specific rows from a table: We can copy specific rows from a table to insert into another table by using WHERE clause with the SELECT statement.

We have used the SELECT statement to copy the data of the selected columns only from the second table and INSERT INTO statement to insert in first table. Names of columns2: name of columns separated by comma(,) for table 2. Names of columns1: name of columns separated by comma(,) for table 1.

INSERT INTO first_table(names_of_columns1) SELECT names_of_columns2 FROM second_table

Inserting specific columns of a table: We can copy only those columns of a table which we want to insert into in a different table.

We have used the SELECT statement to copy the data from one table and INSERT INTO statement to insert in a different table. INSERT INTO first_table SELECT * FROM second_table

Inserting all columns of a table: We can copy all the data of a table and insert into in a different table.

The different ways of using INSERT INTO SELECT statement are shown below: The difference is that the SELECT statement is used here to select data from a different table. We can use the SELECT statement with INSERT INTO statement to copy rows from one table and insert them into another table.The use of this statement is similar to that of INSERT INTO statement.

ISRO CS Syllabus for Scientist/Engineer Exam.

ISRO CS Original Papers and Official Keys.

GATE CS Original Papers and Official Keys.

Corel draw 11 inserting table