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 advanceTry:
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.htmlFLOAT[(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 |