blob: 2e9314db109a0c869f9789734b4009f37dec7dfe (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
DROP TABLE IF EXISTS shops;
CREATE TABLE shops (
location GEOMETRY NOT NULL
);
INSERT INTO shops VALUES (NULL), (NULL);
Warnings:
Warning 1048 Column 'location' cannot be null
Warning 1048 Column 'location' cannot be null
SELECT AsText(location) FROM shops;
AsText(location)
POINT(0 0)
POINT(0 0)
DROP TABLE shops;
|