REAL(m, d): Synonym for DOUBLE. : Double « Data Type « SQL / MySQL






REAL(m, d): Synonym for DOUBLE.

 
mysql>
mysql>
mysql> CREATE TABLE a (
    ->  id INT NOT NULL AUTO_INCREMENT,
    ->  choice REAL,
    ->  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>
mysql>

   
  








Related examples in the same category

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