DOUBLE(m, d): Floating-point number, 16-place accuracy (8 byte). : Double « Data Type « SQL / MySQL

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

DOUBLE(m, d): Floating-point number, 16-place accuracy (8 byte).

 
mysql>
mysql>
mysql>
mysql> CREATE TABLE a (
    ->  id INT NOT NULL AUTO_INCREMENT,
    ->  choice DOUBLE,
    ->  PRIMARY KEY (id));
Query OK, 0 rows affected (0.00 sec)

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

mysql>

   
  

Related examples in the same category