Hi All,
I was wondering if anyone could tell me what is wrong with the following attempt to add a column of decimal type to an existing table...no matter how many different ways I slice/dice the query, MySQL spits back a syntax error from both the command line and going through PhpMyAdmin.
Thanks in advance,
Pat
ALTER TABLE databasename.players ADD average DECIMAL(10) UNSIGNED NOT NULL;
Problem creating decimal type column
Moderator: General Moderators
-
Mayor McCheese
- Forum Newbie
- Posts: 5
- Joined: Tue Apr 23, 2002 12:17 am
- RandomEngy
- Forum Contributor
- Posts: 173
- Joined: Wed Jun 26, 2002 3:24 pm
- Contact: