⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
r
/
View File Name :
key_diff.result
drop table if exists t1; CREATE TABLE t1 ( a char(5) NOT NULL, b char(4) NOT NULL, KEY (a), KEY (b) ); INSERT INTO t1 VALUES ('A','B'),('b','A'),('C','c'),('D','E'),('a','a'); select * from t1,t1 as t2; a b a b A B A B b A A B C c A B D E A B a a A B A B b A b A b A C c b A D E b A a a b A A B C c b A C c C c C c D E C c a a C c A B D E b A D E C c D E D E D E a a D E A B a a b A a a C c a a D E a a a a a a analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status OK explain select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 NULL ALL a NULL NULL NULL 5 100.00 NULL 1 SIMPLE t2 NULL ALL b NULL NULL NULL 5 20.00 Using where; Using join buffer (Block Nested Loop) Warnings: Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` join `test`.`t1` `t2` where (`test`.`t1`.`a` = `test`.`t2`.`b`) select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B order by binary t1.a,t2.a; a b a b A B a a A B b A C c C c a a a a a a b A b A A B select * from t1 where a='a'; a b A B a a drop table t1;