Page 1 of 1
3. Which of the following is NOT a valid SQL statement to insert a record in a table named Food? Food table is defined a
Posted: Fri Jul 08, 2022 6:38 am
by answerhappygod
- 3 Which Of The Following Is Not A Valid Sql Statement To Insert A Record In A Table Named Food Food Table Is Defined A 1 (29.89 KiB) Viewed 33 times
3. Which of the following is NOT a valid SQL
statement to insert a record in a table named Food? Food table is defined as follows: 1 2 CREATE TABLE Food (id INT AUTO_INCREMENT, name VARCHAR(50), price DECIMALS (5,2) unsigned, PRIMARY KEY(id)); INSERT INTO Food (id, name, price) VALUES (NULL, 'Pizza', 6.25); INSERT INTO Food VALUES(NULL, 'Pizza', 6.25),(NULL, 'Chips', 2.00); INSERT INTO Food VALUES ('Pizza', 6.25); INSERT INTO Food (name, price) VALUES ('Pizza', 6.25); Incorrect This is fine (the NULL means that the id values can be automatically generated).