Chris Pollett >
Students > [Bio] |
Deliverable #4Description:
Some sample mySQL statements: Insert a new Restaurant: INSERT INTO `fooddata`.`restaurant` ( `ResName` , `UsrName` , `ResLoc` , `ResRate` , `ResPhone` , `ResMonOpen` , `ResMonClose` , `ResTueOpen` , `ResTueClose` , `ResWedOpen` , `ResWedClose` , `ResThuOpen` , `ResThuClose` , `ResFriOpen` , `ResFriClose` , `ResSatOpen` , `ResSatClose` , `ResSunOpen` , `ResSunClose` ) VALUES ( 'pho queen noodle house', 'Kelly', '1133 Tasman drive, Sunnyvale, CA94089', '3', '4087457753', '9', '21', '9', '21', '9', '21', '9', '21', '9', '21', '9', '21', '9', '21' ); Insert a new Food item: INSERT INTO `fooddata`.`food` ( `FoodName` , `FoodPrice` , `FoodRate` , `ResName` , `ResLoc` , `UsrName` ) VALUES ( 'Jumbo shrimps, jumbo crab claw, pork & chicken (Dry or Soup with thin rice noodle)', '8.75', '4.5', 'pho queen noodle house', '1133 Tasman drive, Sunnyvale, CA94089', 'Kelly' ); Insert a new User: INSERT INTO `fooddata`.`usr` ( `UsrName` , `UsrPhone` , `role` , `UsrLoc` ) VALUES ( 'Angela', '4082593876', '1', 'Siant Lucia street, San Jose, CA 95127' ); |