⚝
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
/
sysschema
/
r
/
View File Name :
fn_list_drop.result
SELECT sys.list_drop('1,2,3,4,5', '1'); sys.list_drop('1,2,3,4,5', '1') 2,3,4,5 SELECT sys.list_drop('1,2,3,4,5', '3'); sys.list_drop('1,2,3,4,5', '3') 1,2,4,5 SELECT sys.list_drop('1,2,3,4,5', '5'); sys.list_drop('1,2,3,4,5', '5') 1,2,3,4 SELECT sys.list_drop('1, 2, 3, 4, 5', '1'); sys.list_drop('1, 2, 3, 4, 5', '1') 2, 3, 4, 5 SELECT sys.list_drop('1, 2, 3, 4, 5', '3'); sys.list_drop('1, 2, 3, 4, 5', '3') 1, 2, 4, 5 SELECT sys.list_drop('1, 2, 3, 4, 5', '5'); sys.list_drop('1, 2, 3, 4, 5', '5') 1, 2, 3, 4 SELECT sys.list_drop('1,2,3,4,5', NULL); ERROR 02200: Function sys.list_drop: in_drop_value input variable should not be NULL SET @sqlmode := @@sql_mode; SELECT @@sql_mode; @@sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SET SESSION sql_mode = sys.list_drop(@@sql_mode, 'STRICT_TRANS_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. SELECT @@sql_mode; @@sql_mode ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SET SESSION sql_mode = @sqlmode; SET @sqlmode := NULL;