Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.117.121.71
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
innodb_gis /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
0.result
28.99
KB
-rw-r--r--
1.result
63.29
KB
-rw-r--r--
alter_spatial_index.result
35.42
KB
-rw-r--r--
bug16236208.result
2.78
KB
-rw-r--r--
bug16266012.result
614
B
-rw-r--r--
bug17057168.result
1.13
KB
-rw-r--r--
check_rtree.result
599
B
-rw-r--r--
create_spatial_index.result
91.58
KB
-rw-r--r--
geometry.result
47.01
KB
-rw-r--r--
gis.result
63.06
KB
-rw-r--r--
gis_split_inf.result
9.9
KB
-rw-r--r--
gis_split_nan.result
23.68
KB
-rw-r--r--
kill_server.result
997
B
-rw-r--r--
multi_pk.result
1.77
KB
-rw-r--r--
point_basic.result
49.9
KB
-rw-r--r--
point_big.result
20.09
KB
-rw-r--r--
precise.result
26.5
KB
-rw-r--r--
repeatable_spatial.result
6.96
KB
-rw-r--r--
rollback.result
224.48
KB
-rw-r--r--
row_format.result
78.11
KB
-rw-r--r--
rt_precise.result
2.08
KB
-rw-r--r--
rtree.result
103.72
KB
-rw-r--r--
rtree_compress.result
1.46
KB
-rw-r--r--
rtree_compress2.result
666
B
-rw-r--r--
rtree_concurrent_srch.result
11.67
KB
-rw-r--r--
rtree_concurrent_srch_2.result
1.02
KB
-rw-r--r--
rtree_crash.result
997
B
-rw-r--r--
rtree_create_inplace.result
1.78
KB
-rw-r--r--
rtree_debug.result
1.57
KB
-rw-r--r--
rtree_drop_index.result
140.8
KB
-rw-r--r--
rtree_estimate.result
8.19
KB
-rw-r--r--
rtree_multi_pk.result
6.98
KB
-rw-r--r--
rtree_old.result
102.68
KB
-rw-r--r--
rtree_purge.result
563
B
-rw-r--r--
rtree_recovery.result
1.48
KB
-rw-r--r--
rtree_rollback1.result
1.29
KB
-rw-r--r--
rtree_rollback2.result
406
B
-rw-r--r--
rtree_search.result
14.36
KB
-rw-r--r--
rtree_split.result
3.83
KB
-rw-r--r--
rtree_undo.result
1.72
MB
-rw-r--r--
types.result
2.96
KB
-rw-r--r--
update_root.result
481
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : rt_precise.result
SET default_storage_engine=InnoDB; DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, g GEOMETRY NOT NULL, KEY gis_key(g(5)) ) ENGINE=InnoDB; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `fid` int(11) NOT NULL AUTO_INCREMENT, `g` geometry NOT NULL, PRIMARY KEY (`fid`), KEY `gis_key` (`g`(5)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 SELECT count(*) FROM t1; count(*) 150 ANALYZE TABLE t1; Table Op Msg_type Msg_text test.t1 analyze status OK EXPLAIN SELECT fid, ST_AsText(g) FROM t1 WHERE ST_Within(g, ST_GeomFromText('Polygon((140 140,160 140,160 160,140 140))')); id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 NULL ALL gis_key NULL NULL NULL # 100.00 Using where Warnings: Note 1003 /* select#1 */ select `test`.`t1`.`fid` AS `fid`,st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where st_within(`test`.`t1`.`g`,<cache>(st_geometryfromtext('Polygon((140 140,160 140,160 160,140 140))'))) SELECT fid, ST_AsText(g) FROM t1 WHERE ST_Within(g, ST_GeomFromText('Polygon((140 140,160 140,160 160,140 160,140 140))')) ORDER BY fid; fid ST_AsText(g) 1 LINESTRING(150 150,150 150) 2 LINESTRING(149 149,151 151) 3 LINESTRING(148 148,152 152) 4 LINESTRING(147 147,153 153) 5 LINESTRING(146 146,154 154) 6 LINESTRING(145 145,155 155) 7 LINESTRING(144 144,156 156) 8 LINESTRING(143 143,157 157) 9 LINESTRING(142 142,158 158) 10 LINESTRING(141 141,159 159) 11 LINESTRING(140 140,160 160) DROP TABLE t1; CREATE TABLE t1 ( fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, g GEOMETRY NOT NULL ) ENGINE=InnoDB; ALTER TABLE t1 ADD SPATIAL KEY(g); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `fid` int(11) NOT NULL AUTO_INCREMENT, `g` geometry NOT NULL, PRIMARY KEY (`fid`), SPATIAL KEY `g` (`g`) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin1 SELECT count(*) FROM t1; count(*) 100 SELECT fid, ST_AsText(g) FROM t1 WHERE ST_Within(g, ST_GeomFromText('Polygon((40 40,60 40,60 60,40 40))')) ORDER BY fid; fid ST_AsText(g) 46 LINESTRING(51 41,60 50) DROP TABLE t1; End of 5.5 tests.
Close
