This is the query i did:

Code:
INSERT INTO LocationTable (LocationName)
VALUES (Bathroom, Kitchen, Bedroom, Hall)