Appendix E. INSERT Statements for Data in 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 populate the tables after you create them.
MySQL and SQL Server
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'); ...
Get Sams Teach Yourself SQL in 24 Hours, Fifth Edition 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.
