You need To provide Multiple lists of values where each list is separated by ','. Value1, Value2, Value3 : value of first column, second column,вЂ¦ for each new row inserted table_name: name of the tableД¬olumn1: name of first column, second column вЂ¦ To insert multiple rows in a table using Single SQL Statement INSERT INTO table_name(Column1,Column2,Column3.).The table Student will now look like, 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 This query will select only the first row from table LateralStudent to insert into the table Student. INSERT INTO Student SELECT * FROM LateralStudent WHERE Age = 18 The table Student will now look like, 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 null null 18 8 NIRAJ null null 19 9 SOMESH null null 20 This query will insert the data in the columns ROLL_NO, NAME and Age of the table LateralStudent in the table Student and the remaining columns in the Student table will be filled by null which is the default value of the remaining columns. 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.The Several innovations to vector based illustration originated with Corel Draw. It is also used to create corporate logos, brochures, banners, letterheads, business cards, magazines, envelopes, catalogs, prospectus, newspaper, newsletters, wedding cards, calendars, stationary etc. Corel Draw is a Designing tool used to make vector art.

Corel draw 11 inserting table