Edit File: update_time.result
DROP TABLE IF EXISTS t1,t2,t3,t4; CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NULL, PRIMARY KEY(c1)); CREATE TABLE t2(c1 TIME NOT NULL, c2 TIME 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:13:13 00:51:51 01:01:01 02:02:02 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; 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=DEFAULT; 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:22:22 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 02:02:02 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;