Computer Science
Rewrite the following SQL statement after correcting the error(s). Underline the corrections made.
INSERT IN STUDENT (RNO, MARKS)
VALUE (5, 78.5);
DDL & DML
1 Like
Answer
INSERT IN STUDENT (RNO, MARKS) -- Error 1
VALUE (5, 78.5); -- Error 2
Error 1 — The correct syntax in SQL for inserting data into a table is "INSERT INTO", not "INSERT IN".
Error 2 — The correct keyword used in SQL to specify the values being inserted into the table is "VALUES", not "VALUE".
The corrected code is:
INSERT INTO STUDENT(RNO, MARKS)
VALUES (5, 78.5);
Answered By
1 Like
Related Questions
Write two advantages of using an Optical Fibre cable over an Ethernet cable to connect two service stations which are 200 m away from each other.
What is the use of "w" in file handling?
Write a function Push() which takes number as argument and add in a stack "MyValue".
Write the output of the following code:
for i in range(5): print(i)