Appendix E. INSERT Statements for Book Examples

This appendix contains the INSERT statements that were used to populate the tables that are listed in Appendix D, “CREATE TABLE Statements for Book Examples.” These INSERT statements can be used to populate the tables in MySQL after you create them.

EMPLOYEE_TBL

INSERT INTO EMPLOYEE_TBL VALUES ('311549902', 'STEPHENS', 'TINA', 'DAWN','RR 3 BOX 17A', 'GREENWOOD', 'IN', '47890', '3178784465',NULL); INSERT INTO EMPLOYEE_TBL VALUES ('442346889', 'PLEW', 'LINDA', 'CAROL', '3301 BEACON', 'INDIANAPOLIS', 'IN', '46224', '3172978990', NULL); INSERT INTO EMPLOYEE_TBL VALUES ('213764555', 'GLASS', 'BRANDON', 'SCOTT', '1710 MAIN ST', 'WHITELAND', 'IN', '47885', '3178984321', '3175709980'); INSERT INTO EMPLOYEE_TBL ...

Get Sams Teach Yourself SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.