Now lets see what is in our table doctor. The difference with this way of inserting data into our tables is that we specify what columns that we are inserting into so the order of the columns is not important. The following insert statement also works ok. Our third form of our insert statement allows us to select data from an existing table or view and insert it into another table. We will now create another table called sarah, like the table doctor it will have columns named 'a' and 'b'.
Lets see the structure of our table sarah.
Now we will insert some data into sarah. Now lets see what's in the table sarah. Our select statement above can also contain where clauses also. And we would get the result.