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 | : 3.142.135.246
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 /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
delete_decimal.result
20.16
KB
-rw-r--r--
delete_time.result
14.73
KB
-rw-r--r--
delete_year.result
5.29
KB
-rw-r--r--
insert_calendar.result
1.51
MB
-rw-r--r--
insert_decimal.result
97.73
KB
-rw-r--r--
insert_number.result
1014.62
KB
-rw-r--r--
insert_time.result
152.97
KB
-rw-r--r--
insert_year.result
225.84
KB
-rw-r--r--
strings_charsets_update_delete...
110.87
KB
-rw-r--r--
strings_update_delete.result
3.04
MB
-rw-r--r--
type_bit_iuds.result
2.84
MB
-rw-r--r--
update_decimal.result
37.2
KB
-rw-r--r--
update_delete_calendar.result
81.06
KB
-rw-r--r--
update_delete_number.result
98.34
KB
-rw-r--r--
update_time.result
24.41
KB
-rw-r--r--
update_year.result
11.18
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : update_time.result
DROP TABLE IF EXISTS t1,t2,t3,t4; SET sql_mode='NO_ENGINE_SUBSTITUTION'; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. 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); 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'); 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'); 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); SET TIMESTAMP=1233216687; 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 INTO t1 VALUES('123456',null); INSERT INTO t3 VALUES('123456',null); INSERT INTO t4 VALUES('123456',null); SELECT * FROM t1; c1 c2 -838:59:55 -838:59:55 -838:59:59 -838:59:59 00:00:00 00:00:00 00:00:01 00:00:01 00:00:04 00:00:04 00:00:07 00:00:07 00:00:08 00:00:08 00:00:09 00:00:09 00:00:10 00:00:10 00:00:11 00:00:11 00:00:12 00:00:12 00:00:14 00:00:14 00:00:50 00:00:50 00:00:53 00:00:53 00:00:59 00:00:59 00:03:00 00:03:00 00:04:00 00:04:00 00:09:09 00:09:09 00:13:13 00:13:13 00:51:51 00:51:51 00:54:54 00:54:54 01:01:01 01:01:01 02:02:02 02:02:02 03:03:00 03:03:00 08:08:08 08:08:08 100:04:04 100:04:04 11:11:11 11:11:11 11:11:27 11:11:27 125:00:00 125:00:00 125:05:00 125:05:00 12:12:12 12:12:12 12:34:56 NULL 150:00:00 150:00:00 838:00:00 838:00:00 838:56:00 838:56:00 838:58:00 838:58:00 838:59:51 838:59:51 838:59:52 838:59:52 838:59:55 838:59:55 838:59:57 838:59:57 838:59:58 838:59:58 838:59:59 838:59:59 SELECT * FROM t2; c1 c2 -838:59:55 -838:59:55 -838:59:59 -838:59:59 00:00:00 00:00:00 00:00:01 00:00:01 00:00:04 00:00:04 00:00:07 00:00:07 00:00:08 00:00:08 00:00:09 00:00:09 00:00:10 00:00:10 00:00:11 00:00:11 00:00:12 00:00:12 00:00:14 00:00:14 00:00:50 00:00:50 00:00:53 00:00:53 00:00:59 00:00:59 00:03:00 00:03:00 00:04:00 00:04:00 00:09:09 00:09:09 00:13:13 00:13:13 00:51:51 00:51:51 00:54:54 00:54:54 01:01:01 01:01:01 02:02:02 02:02:02 03:03:00 03:03:00 08:08:08 08:08:08 100:04:04 100:04:04 11:11:11 11:11:11 11:11:27 11:11:27 125:00:00 125:00:00 125:05:00 125:05:00 12:12:12 12:12:12 150:00:00 150:00:00 838:00:00 838:00:00 838:56:00 838:56:00 838:58:00 838:58:00 838:59:51 838:59:51 838:59:52 838:59:52 838:59:55 838:59:55 838:59:57 838:59:57 838:59:58 838:59:58 838:59:59 838:59:59 SELECT * FROM t3; c1 c2 -838:59:55 -838:59:55 -838:59:59 -838:59:59 00:00:00 00:00:00 00:00:01 00:00:01 00:00:04 00:00:04 00:00:07 00:00:07 00:00:08 00:00:08 00:00:09 00:00:09 00:00:10 00:00:10 00:00:11 00:00:11 00:00:12 00:00:12 00:00:14 00:00:14 00:00:50 00:00:50 00:00:53 00:00:53 00:00:59 00:00:59 00:03:00 00:03:00 00:04:00 00:04:00 00:09:09 00:09:09 00:13:13 00:13:13 00:51:51 00:51:51 00:54:54 00:54:54 01:01:01 01:01:01 02:02:02 02:02:02 03:03:00 03:03:00 08:08:08 08:08:08 100:04:04 100:04:04 11:11:11 11:11:11 11:11:27 11:11:27 125:00:00 125:00:00 125:05:00 125:05:00 12:12:12 12:12:12 12:34:56 NULL 150:00:00 150:00:00 838:00:00 838:00:00 838:56:00 838:56:00 838:58:00 838:58:00 838:59:51 838:59:51 838:59:52 838:59:52 838:59:55 838:59:55 838:59:57 838:59:57 838:59:58 838:59:58 838:59:59 838:59:59 SELECT * FROM t4; c1 c2 -838:59:55 -838:59:55 -838:59:59 -838:59:59 00:00:00 00:00:00 00:00:01 00:00:01 00:00:04 00:00:04 00:00:07 00:00:07 00:00:08 00:00:08 00:00:09 00:00:09 00:00:10 00:00:10 00:00:11 00:00:11 00:00:12 00:00:12 00:00:14 00:00:14 00:00:50 00:00:50 00:00:53 00:00:53 00:00:59 00:00:59 00:03:00 00:03:00 00:04:00 00:04:00 00:09:09 00:09:09 00:13:13 00:13:13 00:51:51 00:51:51 00:54:54 00:54:54 01:01:01 01:01:01 02:02:02 02:02:02 03:03:00 03:03:00 08:08:08 08:08:08 100:04:04 100:04:04 11:11:11 11:11:11 11:11:27 11:11:27 125:00:00 125:00:00 125:05:00 125:05:00 12:12:12 12:12:12 12:34:56 NULL 150:00:00 150:00:00 838:00:00 838:00:00 838:56:00 838:56:00 838:58:00 838:58:00 838:59:51 838:59:51 838:59:52 838:59:52 838:59:55 838:59:55 838:59:57 838:59:57 838:59:58 838:59:58 838:59:59 838:59:59 SELECT c1 FROM t1 WHERE c1='00:00:07'; c1 00:00:07 UPDATE t1 SET c1='22:22:22' WHERE c1='00:00:07'; SELECT c1 FROM t1; c1 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 100:04:04 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 12:34:56 150:00:00 22:22:22 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 SELECT c1 FROM t2 WHERE c1='-838:59:59' AND c2='-838:59:59'; c1 -838:59:59 UPDATE t2 SET c1='22:22:22' WHERE c1='-838:59:59' AND c2='-838:59:59'; SELECT c1 FROM t2; c1 -838:59:55 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 100:04:04 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 22:22:22 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 SELECT c2 FROM t3 WHERE c2=null; c2 UPDATE t3 SET c2='34 22:59:59' WHERE c2=null; SELECT c2 FROM t3; c2 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 100:04:04 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 NULL SELECT c2 FROM t4 WHERE c1='00:00:00'; c2 00:00:00 UPDATE t4 SET c2=null WHERE c1='00:00:00'; SELECT c2 FROM t4; c2 -838:59:55 -838:59:59 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 100:04:04 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 NULL NULL SELECT c1 FROM t4 WHERE c1 < '000009'; c1 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 UPDATE t4 SET c1='0101' WHERE c1 < '000009' ORDER BY c1 LIMIT 3; SELECT c1 FROM t4; c1 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:01:01 00:01:01 00:01:01 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 100:04:04 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 12:34:56 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 SELECT c1 FROM t1 WHERE c1='12:12:12'; c1 12:12:12 UPDATE t1 SET c1='-12:12:12' WHERE c1='12:12:12'; SELECT c1 FROM t1; c1 -12:12:12 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 100:04:04 11:11:11 11:11:27 125:00:00 125:05:00 12:34:56 150:00:00 22:22:22 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 SELECT c1 FROM t1 WHERE c1=111127; c1 11:11:27 UPDATE t1 SET c1=c1+c2 WHERE c1=111127; SELECT c1 FROM t1; c1 -12:12:12 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 100:04:04 11:11:11 125:00:00 125:05:00 12:34:56 150:00:00 22:22:22 22:22:54 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 SELECT c1 FROM t2 WHERE c2='100:04:04'; c1 100:04:04 UPDATE t2 SET c1=c1 - '010101' WHERE c2=1000404; SELECT c1 FROM t2; c1 -838:59:55 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 22:22:22 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 99:03:03 SELECT c2 FROM t3 WHERE c2=020202; c2 02:02:02 UPDATE t3 SET c2=c1 * 2 WHERE c2='020202'; SELECT c1 FROM t3; c1 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 100:04:04 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 12:34:56 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 SELECT c1 FROM t4 WHERE c1=121212; c1 12:12:12 UPDATE t4 SET c1=c1 / 2 WHERE c1='12:12:12'; SELECT c1 FROM t4; c1 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:01:01 00:01:01 00:01:01 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 06:06:06 08:08:08 100:04:04 11:11:11 11:11:27 125:00:00 125:05:00 12:34:56 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 UPDATE t1 SET c2=1250000 WHERE c1='00:00:09' AND c1='01:01:01'; SELECT c2 FROM t1; c2 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 100:04:04 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 NULL UPDATE t2 SET c1=125959 WHERE c2=000400 OR c2= 000900; SELECT c1 FROM t2; c1 -838:59:55 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 12:59:59 150:00:00 22:22:22 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 99:03:03 UPDATE t2 SET c2='1111' WHERE c1 IN ('100:04:04',005454,'2:2:2',111111); SELECT c2 FROM t2; c2 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:11:11 00:11:11 00:11:11 00:13:13 00:51:51 01:01:01 03:03:00 08:08:08 100:04:04 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 UPDATE t4 SET c2='-838:59:60' WHERE c1='100:04:04'; Warnings: Warning 1264 Out of range value for column 'c2' at row 12 SELECT c2 FROM t4; c2 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 NULL NULL UPDATE t4 SET c2='838:59:60' WHERE c1='100:04:04'; Warnings: Warning 1264 Out of range value for column 'c2' at row 12 SELECT c2 FROM t4; c2 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 NULL NULL UPDATE t4 SET c2='00:00:00' WHERE c1='100:04:04'; SELECT c2 FROM t4; c2 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 NULL NULL UPDATE t4 SET c2='11:11:60' WHERE c1='100:04:04'; Warnings: Warning 1264 Out of range value for column 'c2' at row 12 SELECT c2 FROM t4; c2 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 NULL NULL UPDATE t4 SET c2='11:60:11' WHERE c1='100:04:04'; Warnings: Warning 1264 Out of range value for column 'c2' at row 12 SELECT c2 FROM t4; c2 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 NULL NULL SELECT c1 FROM t3 WHERE c2 < '000007'; c1 -838:59:55 -838:59:59 00:00:00 00:00:01 00:00:04 SET SQL_MODE=STRICT_ALL_TABLES; Warnings: Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. UPDATE t3 SET c1=NULL WHERE c2 < '000007'; ERROR 23000: Column 'c1' cannot be null UPDATE IGNORE t3 SET c1=NULL WHERE c2 < '000007'; Warnings: Warning 1048 Column 'c1' cannot be null Warning 1048 Column 'c1' cannot be null Warning 1048 Column 'c1' cannot be null Warning 1048 Column 'c1' cannot be null Warning 1048 Column 'c1' cannot be null SELECT c1 from t3 WHERE c2 < '000007'; c1 00:00:00 00:00:00 00:00:00 00:00:00 00:00:00 SET SQL_MODE='NO_ENGINE_SUBSTITUTION'; UPDATE t1 SET c1=8385958 WHERE c2='34 22:59:59'; ERROR 23000: Duplicate entry '838:59:58' for key 'PRIMARY' UPDATE t1 SET c2='def' WHERE c1=59; Warnings: Warning 1265 Data truncated for column 'c2' at row 1 SELECT c2 FROM t1; c2 -838:59:55 -838:59:59 00:00:00 00:00:00 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 08:08:08 100:04:04 11:11:11 11:11:27 125:00:00 125:05:00 12:12:12 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 NULL UPDATE t4 SET c1=11:11:11 WHERE c2=NULL; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':11:11 WHERE c2=NULL' at line 1 SELECT c1 FROM t4; c1 00:00:01 00:00:04 00:00:07 00:00:08 00:00:09 00:00:10 00:00:11 00:00:12 00:00:14 00:00:50 00:00:53 00:00:59 00:01:01 00:01:01 00:01:01 00:03:00 00:04:00 00:09:09 00:13:13 00:51:51 00:54:54 01:01:01 02:02:02 03:03:00 06:06:06 08:08:08 100:04:04 11:11:11 11:11:27 125:00:00 125:05:00 12:34:56 150:00:00 838:00:00 838:56:00 838:58:00 838:59:51 838:59:52 838:59:55 838:59:57 838:59:58 838:59:59 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 t1 SET t1.c1='00:12:12' WHERE c1='00:09:09' AND c2='00:09:09'; SELECT * FROM t1; c1 c2 -12:12:12 12:12:12 -838:59:55 -838:59:55 -838:59:59 -838:59:59 00:00:00 00:00:00 00:00:01 00:00:01 00:00:04 00:00:04 00:00:08 00:00:08 00:00:09 00:00:09 00:00:10 00:00:10 00:00:11 00:00:11 00:00:12 00:00:12 00:00:14 00:00:14 00:00:50 00:00:50 00:00:53 00:00:53 00:00:59 00:00:00 00:03:00 00:03:00 00:04:00 00:04:00 00:12:12 00:09:09 00:13:13 00:13:13 00:51:51 00:51:51 00:54:54 00:54:54 01:01:01 01:01:01 02:02:02 02:02:02 03:03:00 03:03:00 08:08:08 08:08:08 100:04:04 100:04:04 11:11:11 11:11:11 125:00:00 125:00:00 125:05:00 125:05:00 12:34:56 NULL 150:00:00 150:00:00 22:22:22 00:00:07 22:22:54 11:11:27 838:00:00 838:00:00 838:56:00 838:56:00 838:58:00 838:58:00 838:59:51 838:59:51 838:59:52 838:59:52 838:59:55 838:59:55 838:59:57 838:59:57 838:59:58 838:59:58 838:59:59 838:59:59 UPDATE t1 SET t1.c2='99999.99999' WHERE c1 BETWEEN 080000 AND 100000; Warnings: Warning 1264 Out of range value for column 'c2' at row 1 SELECT * FROM t1; c1 c2 -12:12:12 12:12:12 -838:59:55 -838:59:55 -838:59:59 -838:59:59 00:00:00 00:00:00 00:00:01 00:00:01 00:00:04 00:00:04 00:00:08 00:00:08 00:00:09 00:00:09 00:00:10 00:00:10 00:00:11 00:00:11 00:00:12 00:00:12 00:00:14 00:00:14 00:00:50 00:00:50 00:00:53 00:00:53 00:00:59 00:00:00 00:03:00 00:03:00 00:04:00 00:04:00 00:12:12 00:09:09 00:13:13 00:13:13 00:51:51 00:51:51 00:54:54 00:54:54 01:01:01 01:01:01 02:02:02 02:02:02 03:03:00 03:03:00 08:08:08 00:00:00 100:04:04 100:04:04 11:11:11 11:11:11 125:00:00 125:00:00 125:05:00 125:05:00 12:34:56 NULL 150:00:00 150:00:00 22:22:22 00:00:07 22:22:54 11:11:27 838:00:00 838:00:00 838:56:00 838:56:00 838:58:00 838:58:00 838:59:51 838:59:51 838:59:52 838:59:52 838:59:55 838:59:55 838:59:57 838:59:57 838:59:58 838:59:58 838:59:59 838:59:59 UPDATE t1 SET c1=c1+1,c2=c2-1 WHERE c1 IN (222222,8385955,1500000) ORDER BY c1; Warnings: Warning 1264 Out of range value for column 'c2' at row 2 SELECT * FROM t1; c1 c2 -12:12:12 12:12:12 -838:59:55 -838:59:55 -838:59:59 -838:59:59 00:00:00 00:00:00 00:00:01 00:00:01 00:00:04 00:00:04 00:00:08 00:00:08 00:00:09 00:00:09 00:00:10 00:00:10 00:00:11 00:00:11 00:00:12 00:00:12 00:00:14 00:00:14 00:00:50 00:00:50 00:00:53 00:00:53 00:00:59 00:00:00 00:03:00 00:03:00 00:04:00 00:04:00 00:12:12 00:09:09 00:13:13 00:13:13 00:51:51 00:51:51 00:54:54 00:54:54 01:01:01 01:01:01 02:02:02 02:02:02 03:03:00 03:03:00 08:08:08 00:00:00 100:04:04 100:04:04 11:11:11 11:11:11 125:00:00 125:00:00 125:05:00 125:05:00 12:34:56 NULL 150:00:01 00:00:00 22:22:23 00:00:06 22:22:54 11:11:27 838:00:00 838:00:00 838:56:00 838:56:00 838:58:00 838:58:00 838:59:51 838:59:51 838:59:52 838:59:52 838:59:56 838:59:54 838:59:57 838:59:57 838:59:58 838:59:58 838:59:59 838:59:59 UPDATE t1,t2 SET t1.c2='22222.22222' WHERE t1.c1=t2.c1 AND t1.c2=t2.c2; SELECT * FROM t1; c1 c2 -12:12:12 12:12:12 -838:59:55 02:22:22 -838:59:59 -838:59:59 00:00:00 02:22:22 00:00:01 02:22:22 00:00:04 02:22:22 00:00:08 02:22:22 00:00:09 02:22:22 00:00:10 02:22:22 00:00:11 02:22:22 00:00:12 02:22:22 00:00:14 02:22:22 00:00:50 02:22:22 00:00:53 02:22:22 00:00:59 00:00:00 00:03:00 02:22:22 00:04:00 00:04:00 00:12:12 00:09:09 00:13:13 02:22:22 00:51:51 02:22:22 00:54:54 00:54:54 01:01:01 02:22:22 02:02:02 02:02:02 03:03:00 02:22:22 08:08:08 00:00:00 100:04:04 100:04:04 11:11:11 11:11:11 125:00:00 02:22:22 125:05:00 02:22:22 12:34:56 NULL 150:00:01 00:00:00 22:22:23 00:00:06 22:22:54 11:11:27 838:00:00 02:22:22 838:56:00 02:22:22 838:58:00 02:22:22 838:59:51 02:22:22 838:59:52 02:22:22 838:59:56 838:59:54 838:59:57 02:22:22 838:59:58 02:22:22 838:59:59 02:22:22 SELECT * FROM t2; c1 c2 -838:59:55 -838:59:55 00:00:00 00:00:00 00:00:01 00:00:01 00:00:04 00:00:04 00:00:07 00:00:07 00:00:08 00:00:08 00:00:09 00:00:09 00:00:10 00:00:10 00:00:11 00:00:11 00:00:12 00:00:12 00:00:14 00:00:14 00:00:50 00:00:50 00:00:53 00:00:53 00:00:59 00:00:59 00:03:00 00:03:00 00:09:09 00:09:09 00:13:13 00:13:13 00:51:51 00:51:51 00:54:54 00:11:11 01:01:01 01:01:01 02:02:02 00:11:11 03:03:00 03:03:00 08:08:08 08:08:08 11:11:11 00:11:11 11:11:27 11:11:27 125:00:00 125:00:00 125:05:00 125:05:00 12:12:12 12:12:12 12:59:59 00:04:00 150:00:00 150:00:00 22:22:22 -838:59:59 838:00:00 838:00:00 838:56:00 838:56:00 838:58:00 838:58:00 838:59:51 838:59:51 838:59:52 838:59:52 838:59:55 838:59:55 838:59:57 838:59:57 838:59:58 838:59:58 838:59:59 838:59:59 99:03:03 100:04:04 SELECT * FROM t3; c1 c2 00:00:00 -838:59:55 00:00:00 -838:59:59 00:00:00 00:00:00 00:00:00 00:00:01 00:00:00 00:00:04 00:00:07 00:00:07 00:00:08 00:00:08 00:00:09 00:00:09 00:00:10 00:00:10 00:00:11 00:00:11 00:00:12 00:00:12 00:00:14 00:00:14 00:00:50 00:00:50 00:00:53 00:00:53 00:00:59 00:00:59 00:03:00 00:03:00 00:04:00 00:04:00 00:09:09 00:09:09 00:13:13 00:13:13 00:51:51 00:51:51 00:54:54 00:54:54 01:01:01 01:01:01 02:02:02 04:04:04 03:03:00 03:03:00 08:08:08 08:08:08 100:04:04 100:04:04 11:11:11 11:11:11 11:11:27 11:11:27 125:00:00 125:00:00 125:05:00 125:05:00 12:12:12 12:12:12 12:34:56 NULL 150:00:00 150:00:00 838:00:00 838:00:00 838:56:00 838:56:00 838:58:00 838:58:00 838:59:51 838:59:51 838:59:52 838:59:52 838:59:55 838:59:55 838:59:57 838:59:57 838:59:58 838:59:58 838:59:59 838:59:59 SELECT * FROM t4; c1 c2 00:00:01 00:00:01 00:00:04 00:00:04 00:00:07 00:00:07 00:00:08 00:00:08 00:00:09 00:00:09 00:00:10 00:00:10 00:00:11 00:00:11 00:00:12 00:00:12 00:00:14 00:00:14 00:00:50 00:00:50 00:00:53 00:00:53 00:00:59 00:00:59 00:01:01 -838:59:55 00:01:01 -838:59:59 00:01:01 NULL 00:03:00 00:03:00 00:04:00 00:04:00 00:09:09 00:09:09 00:13:13 00:13:13 00:51:51 00:51:51 00:54:54 00:54:54 01:01:01 01:01:01 02:02:02 02:02:02 03:03:00 03:03:00 06:06:06 12:12:12 08:08:08 08:08:08 100:04:04 00:00:00 11:11:11 11:11:11 11:11:27 11:11:27 125:00:00 125:00:00 125:05:00 125:05:00 12:34:56 NULL 150:00:00 150:00:00 838:00:00 838:00:00 838:56:00 838:56:00 838:58:00 838:58:00 838:59:51 838:59:51 838:59:52 838:59:52 838:59:55 838:59:55 838:59:57 838:59:57 838:59:58 838:59:58 838:59:59 838:59:59 DROP TABLE IF EXISTS t1,t2,t3,t4; SET sql_mode=default;
Close
