Point type column with default value : Point « Geometric « SQL / MySQL






  1. SQL / MySQL
  2. Geometric
  3. Point

Point type column with default value

    
mysql>
mysql> CREATE TABLE cities (
    ->   id int(11) NOT NULL,
    ->   pt point NOT NULL default ''
    -> );
Query OK, 0 rows affected, 1 warning (0.00 sec)

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








Related examples in the same category

1.POINT type column: A point in the coordinate system; zero-dimensional.
2.Find the most westerly and easterly points