[Scarface23]

Hi guys, Im having a problem of getting this database to work.
Heres The Ouput im receiving when trying to use the database:

ERROR 1064 (42000) at line 55: 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 'Players'
--
INSERT INTO Players VALUES (1, 1, 'Erik', 'Bird', 'RHP', 1, 74, ' at line 9

And Here is the section of code around the area of the error:

CREATE TABLE Players (
PlayerID int(2) NOT NULL default '0',
TeamID int(1) NOT NULL,
PlayerFirstName varchar(30) NOT NULL default '',
PlayerLastName varchar(30) NOT NULL default '',
PlayerPosition varchar(3) NOT NULL default '',
PlayerNumber int(2) NOT NULL default '0',
PlayerHeight int(3) NOT NULL default '0',
PlayerWeight int(3) NOT NULL default '0,
PlayerBatThrow varchar(4) NOT NULL default '',
PlayerClass varchar(2) NOT NULL default '',
PRIMARY KEY (PlayerID,TeamID)
) TYPE=MyISAM;

--
-- Dumping data for table 'Players'
--

INSERT INTO Players VALUES (1, 1, 'Erik', 'Bird', 'RHP', 1, 74, 215, 'R/R', 'Fr');
INSERT INTO Players VALUES (2,1,'Andrew', 'Brown', '1B', 2, 72, 195, 'R/R', 'Jr');
INSERT INTO Players VALUES (3,1,'Brandon', 'Buckman', '2B', 3, 77, 225, 'L/L', 'Sr');
INSERT INTO Players VALUES (4,1,'Joba', 'Chamberlain', 'RHP', 4, 75, 225, 'R/R', 'Jr');

[Chicon]

Hi Scarface23,

This should work :

INSERT INTO Players VALUES ( '1', '1', 'Erik', 'Bird', 'RHP', '1', '74', '215', 'R/R', 'Fr' );

It may look weird but numeric values must be enclosed with quotes too !