Question

t) Select the correct SQL statement for insert statement. *
O . Insert into Item value (100,"Pencil", 25);
O ii. Insert into Item values (100,"Pencil”, 25);
O iii. Insert into Item values ("100", Pencil,"25");

Answer 1

Answer:

b) Insert into Item values (100,"Pencil”, 25);

Explanation:

The general format is the INSERT INTO SQL statement followed by a table name, then the list of columns, and then the values that you want to use the SQL insert statement to add data into those columns. Inserting is usually a straightforward task. It begins with the simple statement of inserting a single row.