/* Create and load a table that contains a list

of organizations in Seattle that assist

people in finding jobs

*/

-- Select the database we want to modify

USE dataExamples;

-- New table so if another one with this name exists

DROP TABLE IF EXISTS `organization`;

CREATE TABLE `organization` (

-- Let us have the database provide a unique key

`orgID` INT(5) AUTO_INCREMENT,

-- Organization or Business Name

`orgName` VARCHAR(30) NOT NULL,

-- The Primary Address Line

`orgAddr` VARCHAR(30) NOT NULL,

-- The City of the entity

`orgCity` VARCHAR(20) NOT NULL,

-- The Geographical State of the Entity

`orgState` CHAR(2) NOT NULL,

-- The postal code for the entity

`orgZip` VARCHAR(20) NOT NULL,

PRIMARY KEY(`orgID`)

);

CHAR Function

&

CHAR Data type

How Do I Send A Non-standard Character To The Output ?