Creating a column....

[refik]

Hello all of you,
The following sql script always create a column COL_SCORE in UNSIGNED float type.

DROP TABLE IF EXISTS TBL_SCORES;
CREATE TABLE TBL_SCORES
(
COL_NAME CHAR(32) NOT NULL,
COL_SCORE FLOAT ZEROFILL NOT NULL,
PRIMARY KEY (COL_NAME)
) ENGINE=MyISAM;

Please advice how to create a column whose type is SIGNED float?
Thanks. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Silasa]

You can not use ZEROFILL with SIGNED FLOAT that's why you always get an UNSIGNED one. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --