in manual:
-----------------------------------------
DECIMAL[(M[,D])] [ZEROFILL]
An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR
column: ``unpacked'' means the number is stored as a string, using one
character for each digit of the value. The decimal point and, for negative
numbers, the `-' sign, are not counted in M (but space for these are
reserved). If D is 0, values will have no decimal point or fractional part.
The maximum range of DECIMAL values is the same as for DOUBLE, but the
actual range for a given DECIMAL column may be constrained by the choice of
M and D. If D is left out it's set to 0. If M is left out it's set to 10.
Note that in MySQL Version 3.22 the M argument had to includes the space
needed for the sign and the decimal point.
NUMERIC(M,D) [ZEROFILL]
This is a synonym for DECIMAL.
-------------------------------------------
I suppose that M and D is not optional parameters for NUMERIC type.
----- Original Message -----
From: Esko Lehtme <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 4:36 PM
Subject: Error creating tables
> Can anyone help?
> In this script is one bug but i can't find it :(
>
> create table top(
> Id int(11) DEFAULT '0' NOT NULL auto_increment,
> nadal numeric,
> kuupaev DATE,
> usa1 text,
> usa2 text,
> usa3 text,
> usa4 text,
> usa5 text,
> usa6 text,
> usa7 text,
> usa8 text,
> usa9 text,
> usa10 text,
> eesti1 text,
> eesti2 text,
> eesti3 text,
> eesti4 text,
> eesti5 text,
> tekst longtext,
> PRIMARY KEY (id)
> );
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php