View Single Post
  #1  
Old 12-18-2006, 04:43 AM
refik refik is offline
Junior Member
 
Join Date: Aug 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
refik is on a distinguished road
Default Creating a column....

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 --
Reply With Quote
  Webmaster Forums - View Single Post - Creating a column....
View Single Post
  #1  
Old 12-18-2006, 04:43 AM
refik refik is offline
Junior Member
 
Join Date: Aug 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
refik is on a distinguished road
Default Creating a column....

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 --
Reply With Quote