Creating the Database

As with Listing 6.1, this section will detail the initial construction of the commish database and the initial data load procedures. In this case, the data format will be slightly different. The tables to be loaded will be comma delimited with the first row containing the field names (as opposed to the tab-delimited files from the SESI Application in Chapters 6 and 7). It is important to note that the data tables being imported for this application have already been “scrubbed.” For example, in a comma-delimited file, the customer name “Smak Moduler, Inc.” will screw up a MySQL LOAD DATA statement because LOAD DATA will take the comma to mean that “Smak Moduler” is one field and “Inc.” is another, when in fact they are one ...

Get MySQL Building User Interfaces now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.