O'Reilly logo

Sams Teach Yourself SQL in One Hour a Day, Fifth Edition by Arie D. Jones, Ron Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

APPENDIX BCode Examples to Create Tables

This appendix contains the CREATE TABLE statements for the tables that we used for examples in this book. To create these tables in your database, simply log in to your database as a valid user and then execute each of these commands.

Note that the exact syntax of some implementations of SQL may vary slightly from this code. This is basic SQL code to create tables; the implementations used are Oracle and MySQL.

The CREATE TABLE statements are as follows:

image

image

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required