DECIMAL(7,2) ZEROFILL NOT NULL : Decimal « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Decimal

DECIMAL(7,2) ZEROFILL NOT NULL

     
mysql>
mysql>
mysql> CREATE   TABLE PENALTIES
    ->         (PAYMENTNO     INTEGER NOT NULL PRIMARY KEY,
    ->          EmployeeNO      INTEGER NOT NULL,
    ->          PAYMENT_DATE  DATE NOT NULL,
    ->          AMOUNT        DECIMAL(7,2) ZEROFILL NOT NULL)
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT AMOUNT FROM PENALTIES;
Empty set (0.00 sec)

mysql>
mysql> drop table PENALTIES;
Query OK, 0 rows affected (0.00 sec)

mysql>








Related examples in the same category

1.Decimal and Numeric Data Field Syntax When 123.4567 Is Inserted
2.NUMERIC, DEC Synonym for DECIMAL
3.DECIMAL(p, s) Fixed-point number, saved as a character string;
4.DECIMAL(4,2) for price
5.Insert value to a decimal value column
6.DECIMAL(7,2)
7.Update decimal value
8.Decimal default value