⚝
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
/
suite
/
perfschema
/
r
/
View File Name :
user_var_func.result
set @v1a="Hello"; set @v2a="World"; set @v3a=65; set @v4a=NULL; select @v1a, @v2a, @v3a, @v4a, @v_unknown; @v1a @v2a @v3a @v4a @v_unknown Hello World 65 NULL NULL select VARIABLE_NAME, VARIABLE_VALUE from performance_schema.user_variables_by_thread order by VARIABLE_NAME; VARIABLE_NAME VARIABLE_VALUE v1a Hello v2a World v3a 65 v4a NULL set @v1b="Salut"; set @v2b="La compagnie"; set @v3b=12; set @v4b=NULL; select @v1b, @v2b, @v3b, @v4b, @v_unknown; @v1b @v2b @v3b @v4b @v_unknown Salut La compagnie 12 NULL NULL select VARIABLE_NAME, VARIABLE_VALUE from performance_schema.user_variables_by_thread order by VARIABLE_NAME; VARIABLE_NAME VARIABLE_VALUE v1a Hello v1b Salut v2a World v2b La compagnie v3a 65 v3b 12 v4a NULL v4b NULL select VARIABLE_NAME, VARIABLE_VALUE from performance_schema.user_variables_by_thread order by VARIABLE_NAME; VARIABLE_NAME VARIABLE_VALUE v1a Hello v2a World v3a 65 v4a NULL set @blob_under_16_bits=repeat("a", 65000); set @blob_under_24_bits=repeat("a", 1000000); select length(@blob_under_16_bits); length(@blob_under_16_bits) 65000 select length(@blob_under_24_bits); length(@blob_under_24_bits) 1000000 select variable_name, length(variable_value) from performance_schema.user_variables_by_thread where VARIABLE_NAME like "blob%" order by VARIABLE_NAME; variable_name length(variable_value) blob_under_16_bits 65000 blob_under_24_bits 1000000 set @a=10; CREATE procedure test_user_val (IN input INT,OUT output INT) BEGIN SELECT input + input INTO output; END| CALL test_user_val(@a , @total); select VARIABLE_NAME,VARIABLE_VALUE from performance_schema.user_variables_by_thread where variable_name in ('a','total') order by VARIABLE_NAME; VARIABLE_NAME VARIABLE_VALUE a 10 total 20 create table t1 (c1 int); CREATE TRIGGER test_uvar_trigger AFTER INSERT ON t1 FOR EACH ROW BEGIN set @a=@a+@a; END| insert into t1 values(1); select VARIABLE_NAME,VARIABLE_VALUE from performance_schema.user_variables_by_thread where variable_name ='a' order by VARIABLE_NAME; VARIABLE_NAME VARIABLE_VALUE a 20 insert into t1 values(1); select VARIABLE_NAME,VARIABLE_VALUE from performance_schema.user_variables_by_thread where variable_name ='a' order by VARIABLE_NAME; VARIABLE_NAME VARIABLE_VALUE a 40 drop table t1; drop procedure test_user_val;