mysql> create table TBL_personnel(id int auto_increment, fname varchar(25), lname varchar(60), adt varchar(8) unique, gender enum('M','F') not null, salary decimal(10,2) default 0.00, address point not null, primary key(id), spatial index(address));
Query OK, 0 rows affected (0,07 sec)

mysql> insert into TBL_personnel(fname,lname,adt,gender,salary,address) values('Γεωργιος','Γεωργιου','ΑΝ678902','M',12345.67,ST_GeomFromText('POINT(39.6553129 20.8433709)'));
Query OK, 1 row affected (0,00 sec)

mysql> insert into TBL_personnel(fname,lname,adt,gender,salary,address) values('Μιχαηλ','Γεωργιου','ΑΝ674145','M',73481.67,ST_GeomFromText('POINT(39.6553129 20.8433709)'));
Query OK, 1 row affected (0,00 sec)

mysql> insert into TBL_personnel(fname,lname,adt,gender,salary,address) values('Αννα','Ιωαννιδου','ΑΝ681256','F',7356.77,ST_GeomFromText('POINT(39.6350718 20.82936)'));
Query OK, 1 row affected (0,01 sec)

mysql> insert into TBL_personnel(fname,lname,adt,gender,salary,address) values('Αννα','Παπαδοπουλου','ΑΝ690876','F',4561.77,ST_GeomFromText('POINT(39.6765637 20.8470692)'));
Query OK, 1 row affected (0,00 sec)

mysql> insert into TBL_personnel(fname,lname,adt,gender,salary,address) values('Ανεστης','Παπαδοπουλος','ΑM834824','M',4325.89,ST_GeomFromText('POINT(39.6765637 20.8470692)'));
Query OK, 1 row affected (0,00 sec)

mysql> insert into TBL_personnel(fname,lname,adt,gender,salary,address) values('Αναστασια','Παππα','ΑM836784','F',4555.89,ST_GeomFromText('POINT(39.6765637 20.8470692)'));
Query OK, 1 row affected (0,00 sec)

mysql> insert into TBL_personnel(fname,lname,adt,gender,salary,address) values('Ελενη','Τζηκα','ΑΝ567784','F',6685.99,ST_GeomFromText('POINT(39.6880472 20.829226)'));
Query OK, 1 row affected (0,00 sec)

mysql> insert into TBL_personnel(fname,lname,adt,gender,salary,address) values('Κωνσταντινος','Τζηκας','ΑΝ566724','M',6789.05,ST_GeomFromText('POINT(39.6880472 20.829226)'));
Query OK, 1 row affected (0,00 sec)

mysql> insert into TBL_personnel(fname,lname,adt,gender,salary,address) values('Δημητρης','Ρουβας','ΑΝ101894','M',3789.05,ST_GeomFromText('POINT(39.6802461 20.829028)'));
Query OK, 1 row affected (0,00 sec)

mysql> insert into TBL_personnel(fname,lname,adt,gender,salary,address) values('Δημητρης','Λαζαρου','ΑΝ108884','M',3123.6,ST_GeomFromText('POINT(39.6639439 20.9224227)'));
Query OK, 1 row affected (0,00 sec)
