Problem creating decimal type column
Posted: Wed Aug 07, 2002 3:28 pm
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;
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;