MySQL: zerofill error I'm trying to create a table as below

• notverybright / 212 / Mon, 15 Feb 2010 03:11:00 GMT / Comments (2)
• Hello
  I'm trying to create a table as below
  CREATE TABLE MyTable (ID FLOAT NOT NULL PRIMARY KEY ZEROFILL, Forename
  VARCHAR(30),Surname VARCHAR(30));
  If I remove ZEROFILL it works ok
  But with ZEROFILL I get and error (1064)
  I've tried ZEROFILL in different places and I'm stumped.
  Please help
  Best regards and thanks in advance
• Keywords:

  zerofill, error, trying, create, table, below, mysql

• http://database.itags.org/mysql/62217/«« Last Thread - Next Thread »»

• 1. NotVeryBright wrote:
     
     > Hello
     > I'm trying to create a table as below
     > CREATE TABLE MyTable (ID FLOAT NOT NULL PRIMARY KEY ZEROFILL, Forename
     > VARCHAR(30),Surname VARCHAR(30));
     > If I remove ZEROFILL it works ok
     > But with ZEROFILL I get and error (1064)
     > I've tried ZEROFILL in different places and I'm stumped.
     > Please help
     > Best regards and thanks in advance
     
     Try:
     CREATE TABLE MyTable (ID FLOAT ZEROFILL NOT NULL PRIMARY KEY, Forename
     VARCHAR(30),Surname VARCHAR(30));
     
     From the DOCS:
     >http://dev.mysql.com/doc/refman/5.0...e-overview.html
     
     FLOAT[(M,D)] [UNSIGNED] [ZEROFILL]
     
     A small (single-precision) floating-point number. Allowable values are
     -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to
     3.402823466E+38. These are the theoretical limits, based on the IEEE
     standard. The actual range might be slightly smaller depending on your
     hardware or operating system.
     
     M is the total number of decimal digits and D is the number of digits
     following the decimal point. If M and D are omitted, values are stored to
     the limits allowed by the hardware. A single-precision floating-point
     number is accurate to approximately 7 decimal places.
     
     If you specify ZEROFILL for a numeric column, mysql automatically adds the
     UNSIGNED attribute to the column.
     
     UNSIGNED, if specified, disallows negative values.

     noone | Fri, 23 May 2008 14:20:00 GMT |

  2. Thanks Noone,
     Tried it out works fine
     Thanks very much
     and Best regards

     notverybright | Fri, 23 May 2008 14:21:00 GMT |