Insert value to a decimal value column : Decimal « Data Type « SQL / MySQL






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

Insert value to a decimal value column

    
mysql>
mysql> CREATE TABLE dishes (
    ->     dish_id INT,
    ->     dish_name VARCHAR(255),
    ->     price DECIMAL(4,2),
    ->     is_spicy INT
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> INSERT INTO dishes (dish_id, dish_name, price, is_spicy)
    ->     VALUES (1, 'Braised Sea Cucumber', 6.50, 0);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> drop table dishes;
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.DECIMAL(7,2)
6.DECIMAL(7,2) ZEROFILL NOT NULL
7.Update decimal value
8.Decimal default value