INSERT VALUE INTO NEW TABLE FOR THE FIRST TIME
when we insert values in the new table for the first time, must we list the column names? i dont understand why my answer wrong
1 answers ( 0 marked as helpful)
Hi Thu!
Thanks for reaching out.
Given that we provide values for all columns of a data table and we do that in the correct order, it is not necessary to specify the column names in the INSERT statement. Please feel free to revise the relevant lecture from the INSERT section of the course for more clarification. Thank you.
Hope this helps.
Best,
Martin