Multiple choice technology databases

The right syntax insert a row into a table is

  1. Insert to table tablename (….);

  2. Insert into table tablename (….);

  3. Insert into table tablename values (…..);

  4. Any one of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Correct INSERT syntax is INSERT INTO tablename VALUES (...). Option A has 'Insert to' instead of 'Insert into'. Option B is missing the VALUES keyword. Option C is correct: INSERT INTO tablename VALUES (...). Note: Option C says 'Insert into table tablename' which has an extra 'table' - the standard is just 'INSERT INTO tablename VALUES (...)'.

Keep practicing — related questions