When I try to drop the following code (in bold) into mySQL, I keep getting error #1064

CREATE TABLE dataprofiles (
profilenumber char(25) DEFAULT 'profilenumber' NOT NULL,
AdHeadline char(35) DEFAULT 'AdHeadline' NOT NULL,
EmailAddress char(50) DEFAULT 'EmailAddress' NOT NULL,
TelephoneAreaCode char(3) DEFAULT 'TelephoneAreaCode' NOT NULL,
City char(50) DEFAULT 'City' NOT NULL,
StateProvince char(50) DEFAULT 'StateProvince' NOT NULL,
Zip char(6) DEFAULT 'Zip' NOT NULL,
Country char(50) DEFAULT 'Country' NOT NULL,
RelationshipPreference char(50) DEFAULT 'RelationshipPreference' NOT NULL,
SexualPreference char(50) DEFAULT 'SexualPreference' NOT NULL,
Username char(12) DEFAULT 'Username' NOT NULL,
Password char(12) DEFAULT 'Password' NOT NULL,
VerifyPassword char(12) DEFAULT 'VerifyPassword' NOT NULL,
SmokingPreference char(50) DEFAULT 'SmokingPreference' NOT NULL,
DrinkingPreference char(50) DEFAULT 'DrinkingPreference' NOT NULL,
MaritialStatus char(50) DEFAULT 'MaritialStatus' NOT NULL,
HaveChildren char(50) DEFAULT 'HaveChildren' NOT NULL,
BodyBuild char(50) DEFAULT 'BodyBuild' NOT NULL,
Height char(50) DEFAULT 'Height' NOT NULL,
Religion char(50) DEFAULT 'Religion' NOT NULL,
Race char(50) DEFAULT 'Race' NOT NULL,
AstrologicalSign char(50) DEFAULT 'AstrologicalSign' NOT NULL,
Age char(3) DEFAULT 'Age' NOT NULL,
Occupation char(50) DEFAULT 'Occupation' NOT NULL,
MiscComments char(250) DEFAULT 'MiscComments' NOT NULL,
PRIMARY KEY(Username,EmailAddress)
);

_________________________________________

Error messages:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TelephoneAreaCode char(3) DEFAULT 'TelephoneAreaCode' NOT NULL,' at line 1

#1064 - same error for 'VerifyPassword char(12) DEFAULT 'VerifyPassword' NOT NULL,'


What am I doing wrong with these lines? The other strings worked Just Fine

It is my belief that "TelephoneAreaCode" has more than 3 letters in it

TelephoneAreaCode char(3) DEFAULT 'TelephoneAreaCode' NOT NULL,

I just changed it to:

CREATE TABLE dataprofiles (
profilenumber char(25) DEFAULT 'profilenumber' NOT NULL,
AdHeadline char(35) DEFAULT 'AdHeadline' NOT NULL,
EmailAddress char(50) DEFAULT 'EmailAddress' NOT NULL,

TelephoneAreaCode char(17) DEFAULT 'TelephoneAreaCode' NOT NULL,

City char(50) DEFAULT 'City' NOT NULL,
StateProvince char(50) DEFAULT 'StateProvince' NOT NULL,
Zip char(6) DEFAULT 'Zip' NOT NULL,
Country char(50) DEFAULT 'Country' NOT NULL,
RelationshipPreference char(50) DEFAULT 'RelationshipPreference' NOT NULL,
SexualPreference char(50) DEFAULT 'SexualPreference' NOT NULL,
Username char(12) DEFAULT 'Username' NOT NULL,
Password char(12) DEFAULT 'Password' NOT NULL,

VerifyPassword char(14) DEFAULT 'VerifyPassword' NOT NULL,

SmokingPreference char(50) DEFAULT 'SmokingPreference' NOT NULL,
DrinkingPreference char(50) DEFAULT 'DrinkingPreference' NOT NULL,
MaritialStatus char(50) DEFAULT 'MaritialStatus' NOT NULL,
HaveChildren char(50) DEFAULT 'HaveChildren' NOT NULL,
BodyBuild char(50) DEFAULT 'BodyBuild' NOT NULL,
Height char(50) DEFAULT 'Height' NOT NULL,
Religion char(50) DEFAULT 'Religion' NOT NULL,
Race char(50) DEFAULT 'Race' NOT NULL,
AstrologicalSign char(50) DEFAULT 'AstrologicalSign' NOT NULL,
Age char(3) DEFAULT 'Age' NOT NULL,
Occupation char(50) DEFAULT 'Occupation' NOT NULL,
MiscComments char(250) DEFAULT 'MiscComments' NOT NULL,
PRIMARY KEY(Username,EmailAddress)
);
CREATE TABLE bookmarks (
Username char(12) DEFAULT 'Username' NOT NULL,
Bookmark char(12) DEFAULT 'Bookmark' NOT NULL,
mix char(25) DEFAULT 'mix' NOT NULL,
PRIMARY KEY(mix)
);
CREATE TABLE emails (
messagenumber char(25) DEFAULT 'messagenumber' NOT NULL,
Sender char(12) DEFAULT 'Sender' NOT NULL,
Recipient char(12) DEFAULT 'Recipient' NOT NULL,
Date char(25) DEFAULT 'Date' NOT NULL,
Subject char(75) DEFAULT 'Subject' NOT NULL,
Message char(250) DEFAULT 'Message' NOT NULL,
PRIMARY KEY(messagenumber)
);

________________________

And it worked. Thanks again C.C.

I would seriously suggest that you rethink the datatypes and structure you are using, the way your tables are set means that you are setting yourself up for severe problems at some point in the future.

Are you talking security risks?

if so, I will bet you anything that you're right. I'm a beginner trying to learn PHP and MySQL with free scripts I found online with their GNU licenses.

He is talking about this (for example):

CREATE TABLE `dataprofiles` (
  `profilenumber` int(11) unsigned NOT NULL auto_increment,
  `AdHeadline` varchar(50) NOT NULL default '',
  `EmailAddress` varchar(50) NOT NULL default '',
  `TelephoneAreaCode` int(3) unsigned zerofill NOT NULL default '000',
  `City` varchar(50) NOT NULL default '',
  `StateProvince` varchar(50) NOT NULL default '',
  `Zip` int(5) unsigned zerofill NOT NULL default '00000',
  `Country` varchar(50) NOT NULL default 'Country',
  `RelationshipPreference` varchar(50) NOT NULL default 'RelationshipPreference',
  `SexualPreference` varchar(50) NOT NULL default 'SexualPreference',
  `Username` varchar(12) NOT NULL default 'Username',
  `Password` varchar(32) NOT NULL default 'Password',
  `SmokingPreference` tinyint(1) unsigned NOT NULL default '0',
  `DrinkingPreference` tinyint(1) unsigned NOT NULL default '0',
  `MaritialStatus` varchar(50) NOT NULL default 'MaritialStatus',
  `HaveChildren` tinyint(1) unsigned NOT NULL default '0',
  `BodyBuild` varchar(50) NOT NULL default 'BodyBuild',
  `Height` varchar(50) NOT NULL default 'Height',
  `Religion` varchar(50) NOT NULL default 'Religion',
  `Race` varchar(50) NOT NULL default 'Race',
  `AstrologicalSign` varchar(50) NOT NULL default 'AstrologicalSign',
  `Age` int(3) unsigned NOT NULL default '0',
  `Occupation` varchar(50) NOT NULL default 'Occupation',
  `MiscComments` text,
  PRIMARY KEY  (`profilenumber`)
) ENGINE=InnoDB ;

Changing the profilenumber to the primary auto increment int type

Changing number fields to integer types

Removing unneeded default values

Changing password field to 32 char firld so you can store a 32 bit hash of the password instead of the raw text string

Changing preferences fileds to a tinyint bool type (0=false and 1=true)

Changing comments into a text type to allow for larger data storage, and change to null type to save room if there are no additional comments

Keith has it pegged right.

You appear to be setting the datatypes and field sizes to suit the NAME of the column. I would guess at the idea being, you can then use the default inserted value as a "prompt" for values that were missed off by the user, which is a rather poor way of handling user input.
It simply inflates the data storage unnecessarily AND gives a false sense of security when handling the data in the back end system.
Ok, you won't get any errors caused by trying to process a NULL value, BUT you should be learning to handle NULL values from the outset, because there will be instances in the future where values may well be NULL and you have no control over the database you are querying.
As Keith points out having NULL fields on some datatypes can be a huge saving on storage space.

I just went to school, lol

Lot of info here for this beginner to digest.

People don't like nulls anymore? They're a valuable tool, and this is the right situation for a null value.